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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Backup advice

Author  Topic 

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2009-11-18 : 07:17:03
Hi,

Ive developed a database for our office here, but we have a client in the US and he'd like to play around with all the tables and SP's and Functions ive implemented for the frontend and reports.

I know just providing a read only access wont allow him to do all that or to give him full view access, otherwise if he makes changes to a SP itll affect the reports and website at the moment.

Would you recommend I backup the database and he is able to restore it onto his server/machine there?

thanks

f

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-18 : 10:32:47
Yes that would be a good idea. Any changes he makes, have him script them out and send to you for review and then you can decide whether or not to apply them to your database.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -