>>Hi everybody,
>>
>>I have a database on the test server. I also used to have a database on the local PC, but not anymore (though I found some MDB file).
>>
>>My question is - what would be the simplest way to copy the database from the test server to the local PC and how would I adjust the connection string to use it locally?
>>
>>Thanks a lot in advance.
>
>
>Naomi,
>
>Please find example script below:
>
>
>BACKUP DATABASE MyDatabaseName
>TO DISK = 'c:\Backups'
>WITH DESCRIPTION = 'This is a backup description',
>NOFORMAT, INIT, NAME = 'BackupName.bak', SKIP, NOREWIND, NOUNLOAD, STATS = 10
>
>
>This should work on SQL2000-SQL2005 all versions.
>
>
>Regards,
>
>Zoran
Something was wrong with this command which I executed as is. The file name was created as Backups (I put c:\Development\Backups and I didn't create Backup directory myself - was this an error)?
Anyway, I'll try to restore from this file now, thanks again.
If it's not broken, fix it until it is.
My Blog