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.
| Author |
Topic |
|
cnsspd
Starting Member
1 Post |
 Posted - 2011-12-05 : 09:33:01
|
| I would like to know what rights are needed to restore a .bak backup of MSSQL to another server. I am moveing a sql database for a website from one hosting company to another and I am getting this error.from this command microsoft management studio. The website company says that the security is set up correcty and they can not help with the restore.RESTORE DATABASE bg FROM DISK = 'Z:\MSSQL1-12-2-11.bak';Msg 262, Level 14, State 1, Line 1CREATE DATABASE permission denied in database 'master'.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-12-05 : 12:39:46
|
From Books Online for RESTORE DATABASE:quote:
If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists, RESTORE permissions default to members of the sysadmin and dbcreator fixed server roles and the owner (dbo) of the database (for the FROM DATABASE_SNAPSHOT option, the database always exists).
Let the hosting company know that they can either grant you CREATE DATABASE or they can create an empty bg database to get around this issue. If they are unwilling to help you, then you'll need to switch hosting companies. Doesn't sound like they are very helpful anyway.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Rights needed to restore .bak to MSSQL server