>>>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
>
>Right, I was trying to do it through the interface, by selecting Back up dialog in SSMS.
Naomi,
In "Backup Database" dialog screen,
select Destination->Back up to:->Disk
Then click on "Add" button
Type in the Path and Filename and Click Ok
Regards,
Zoran