>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