Thank you Geert for your help, in response to your questions
1. I am using the wizard
2. I have tried the backup route but could not get the new server to
recognise the backup file (even though i tried the read back up file and add
back up information option)
any help would be appriciated
[quoted text, click to view] "Geert Vanhove" wrote:
> Are yoy using the database wizard or are yoy performing these actions manually?
> In the second case, you should perform a detach of your live Db before
> starting the copy.
> Another (even better) way is to use a Db backup and restore it on a
> different server.
>
> "Mbladen" wrote:
>
> > Hi,
> >
> > I'm trying to copy a live database onto a test server so that I can do some
> > work without messing up the live.
> >
> > I seem to of sorted out the Logins, i'm using windows authenticaition and
> > have the same user that I have logged in with set up as the service logon
> > within SQL (had lots of failiures before that).
> >
> > Now everything goes through fine succesfully creates the share
> > starts the copy
> > into single usermode
> > detatches the database
> > but the actual .mdf file copy fails with no message just "Fail"
> >
In the restore wizard, did you go into the Options table and make sure the
drives/folders were set properly for the different server? What error are
you getting, exactly, when you try to restore?
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic --
[quoted text, click to view] "Mbladen" <Mbladen@discussions.microsoft.com> wrote in message
news:579B8791-5B54-499C-9C02-53FEF3F574EE@microsoft.com...
> Thank you Geert for your help, in response to your questions
>
> 1. I am using the wizard
> 2. I have tried the backup route but could not get the new server to
> recognise the backup file (even though i tried the read back up file and
add
> back up information option)
>
> any help would be appriciated
>
> "Geert Vanhove" wrote:
>
> > Are yoy using the database wizard or are yoy performing these actions
manually?
> > In the second case, you should perform a detach of your live Db before
> > starting the copy.
> > Another (even better) way is to use a Db backup and restore it on a
> > different server.
> >
> > "Mbladen" wrote:
> >
> > > Hi,
> > >
> > > I'm trying to copy a live database onto a test server so that I can do
some
> > > work without messing up the live.
> > >
> > > I seem to of sorted out the Logins, i'm using windows authenticaition
and
> > > have the same user that I have logged in with set up as the service
logon
> > > within SQL (had lots of failiures before that).
> > >
> > > Now everything goes through fine succesfully creates the share
> > > starts the copy
> > > into single usermode
> > > detatches the database
> > > but the actual .mdf file copy fails with no message just "Fail"
> > >
> > > anyone have any ideas? thanks
