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 Development (2000)
 Saving database

Author  Topic 

derok
Starting Member

14 Posts

Posted - 2007-11-30 : 00:15:33
Hi,
i have created my database in sql server 2000, and i want to save that database, so i can open it in another computer,

how can i do this?


thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-30 : 00:18:56
BACKUP/RESTORE or sp_detach_db/sp_attach_db. Check them out in SQL Server Books Online.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -