May 13, 2014 at 6:58 am
Hello all.
I am going to request that our hosting and development company create a back up of one of our large databases. My goal is to restore it locally in my SQL Server Express 2012 so I can create some database diagrams. As it is now, I do not have permissions to create these diagrams as my role is not defined as an owner of any type/group.
My concern is that if I restore an exact copy, all the roles, groups, permissions and restrictions will come with it. How do I know that when I restore it locally that I can essentially be the owner? I just just use Windows Auth to work with SQL Server Express locally.
How do I know I won't be creating the same problem locally?
May 13, 2014 at 7:11 am
for your local SQL instance, I'm sure you are sysadmin of the box;
that means any database you create or restore on that locla isntance will be under your umbrella, so you will not have any issues via permissions...your sysadmin powers will override whatever permissions might be contained inside the database that you are restoring.
so to be clear, lets say you restore a database that you normally only have db_datareader rights, or even more restricted rights, like you can only see two views, and no tables at all
if you restore the database on your local server where you are sysadmin, you will have full dbo rights...create,delete,drop, everything.
Lowell
May 13, 2014 at 7:29 am
OK. Thanks. Hope you're right. Will know soon enough.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy