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
 Import/Export (DTS) and Replication (2000)
 Restoring a database

Author  Topic 

csphard
Posting Yak Master

113 Posts

Posted - 2010-05-26 : 16:27:38
We have a .bak and wanted to know does the database have to exist before you restore it.

Do we need to create an empty database and then restore it.

Or can we just say restore it and it will create the database..

Howard

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-26 : 16:53:09
You do not need to create an empty database to restore it. If it does exist, then you need WITH REPLACE. If it doesn't exist, then you can either leave that off or include it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -