Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Urgent -Restore

Author  Topic 

venkath
Posting Yak Master

202 Posts

Posted - 2006-06-06 : 04:32:49
Hi guys,,

I have a database and its back up files in server A

using these back up files, i want to create the sampe database in
server B.

How can i do it using restore option in Enterprise Manager...


Thanks in advance.


jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-06-06 : 04:33:47
did you try to restore the database files (which I assume you have copied over server B) in enterprise manager?

did you encounter any difficulty?

--------------------
keeping it simple...
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-06-06 : 04:53:11
See also (to do it using Query Analyser instead of Enterprise Manager):

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen
Go to Top of Page
   

- Advertisement -