Sql Server 2005 create a db from a backup

Evil Phil

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

tiptap

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

fasty

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

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

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

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.