December 13, 2009 at 1:02 am
Hello Everyone,
i want to take the bkp of login scripts, using generate scripts we can take,
But when i am going with generate scripts objects scripts also coming along with the login scripts,
1) I want to take only login scripts,i dont want to take objects scripts ..???
2) I want to schedule this task everyday how to do this ???
Thanks,
December 13, 2009 at 1:40 am
We script all objects of all user databases at least once a week (including all DDL and grant scripts) using SQLSMO.
These scrips a safeguarded in parallel with the visual source safe our dev teams are using.
And yes, at least once of twice a year, I'm asked to pull back a mistakenly rolled out sproc, function, or other object, so this insurance proves itself to be usefull and worth the investment.
"But they could have done that using their VSS" you may argue.
If they only would use it the way it is supposed to ... indeed.
Do I have the worst dev teams ? Certainly not !!
In many cases they have tight deadlines, causing them to over rule the safeguard systems that have been implemented for their own support.
IMO a dba needs to protect her/his database systems and have her/his version of the actual truth.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 13, 2009 at 10:06 am
Microsoft provides a couple of stored procedures that can do this for you. Pick the appropriate version of their code from the following link:
Transfer Logins between Servers via Script
and then all you have to do is call the stored procedure in a job everynight that outputs the printed results to a text file. If you use logging in SQL Agent it can accomplish this.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply