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 |
|
rpc86
Posting Yak Master
200 Posts |
 Posted - 2006-03-02 : 21:14:03
|
Hi guys,Thanks for the recent help.I created a database in MS SqlServer 2000 (Windows XP Pro). I made a backup for this database then I tried to restore this on my MS SQL Server 7 (Windows 2000 Server).The restoration failed because of this error message:[SQL-DMO] You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator to perform this operation. What should I do? |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-03-03 : 00:47:36
|
| Hi,For restoring a database, you should have create database permissions if the database being restored does not exist. If the database being restored does exist, you should have Restore permissions granted to you, or you should be a member of the sysadmin or dbcreator fixed server roles, or you need to be the owner (dbo) of the database |
 |
|
|
|
|
|
RESTORE DATABASE Question