Sql Server 2005 create a db from a backup

Evil Phil · 25-03-2008 04:56PM #1

All I have is the .bak file, can this be used to create a new database? If so, how?

tiptap · 25-03-2008 05:12PM

http://msdn2.microsoft.com/en-us/library/ms177429.aspx

fasty · 25-03-2008 06:12PM

There's probably a better way, but what I do is make a new blank database then follow the instructions linked by tiptap above. You might need to overwrite the existing database the first time at least.

Evil Phil · 25-03-2008 07:11PM

tiptap wrote: »

http://msdn2.microsoft.com/en-us/library/ms177429.aspx

That's not what I want, I'm not restoring a database I'm creating one:

http://msdn2.microsoft.com/en-us/library/ms186390.aspx

seamus · 25-03-2008 08:27PM

Evil Phil wrote: »

That's not what I want, I'm not restoring a database I'm creating one:

http://msdn2.microsoft.com/en-us/library/ms186390.aspx

That should do the job. If it's an entirely different server though, you'll need to check permissions and that - with the exception of dbo, the same users won't exist, which may screw with views and schemas.

On SQL Server, you have to create the user to have server access and then you can link the server user to a database user. Database backups will create the database users, whether or not the corresponding server users exist.

stevenmu · 26-03-2008 08:12PM

You've probably done this by now, but if not when restoring also go into the options and choose to restore over existing database and also check the file paths that it's going to use, IIRC it will try to restore to the same path/filename as the original DB and not the new one you created, which may or may not be ok in your case but worth checking first.

Sql Server 2005 create a db from a backup

Comments