Ads 468x60px

.

Pages

Saturday, April 30, 2011

Backup \ Restore - SQL Permissions

Hello again,
The case :
Sometime this month I was performing a restore from the MOSS GUI, and I got the following error :


                                              



It turned out to be an SQL Permission Problem, since the "SQL guys" gave me DB Creator and not SYSADMIN Permission as needed, I was able to create a new DB but what I couldn't do is to set a reference to it in the MASTER db.

Conclusion – always check your Permissions before you start a backup \ restore

0 comments:

Post a Comment