Viewing 10 posts - 31 through 40 (of 40 total)
What are some of the ways that you guys go about test-restoring your backups?
Is it automated or is it all manual? If it is automated what tools or scripts...
July 25, 2012 at 8:35 am
Thanks for all of the input everybody. Disabled the indexes and haven't seen any issues.
July 10, 2012 at 8:46 am
Steve Jones - SSC Editor (7/9/2012)
I'd concur with Alan on the disabling them. Easier to put them back if you have issues.
Would it be better to simply right click ->...
July 9, 2012 at 12:38 pm
XMLSQLNinja (7/9/2012)
July 9, 2012 at 8:52 am
Joie Andrew (7/5/2012)
Is it a third-party app database or an in-house app that you have reach-back to the devs?
I'm going to get with the "owner" of the database and...
July 6, 2012 at 7:22 am
Another book I recommend is SQL Server 2008 Administration in Action by Rod Colledge. It has a lot of practical techniques, best practices, and even a recommended work flow. It...
June 28, 2012 at 8:40 am
jr.sqldba (6/28/2012)
Hello,Please suggest me one best book for learning total concepts of sql server administration.
Thank you,
sri.
There are probably hundreds of books out there for this. You've just got to find...
June 28, 2012 at 7:35 am
Thanks everyone - all good advice.
One of the issues we face is that we only have a 1Gbit network connection for our backup servers. It can take quite a...
June 26, 2012 at 1:16 pm
Lynn - thanks for the input. I'm going to use this quote going forward: "backups are worthless, restores are priceless."
Grant - Awesome articles and examples. Gives me some ammunition...
June 22, 2012 at 9:58 am
This was much easier than I first anticipated....
Updated the script below to output to table (search YOUR.TABLE.NAME.HERE to edit).
This is a pretty handy script nonetheless....
--http://www.databasejournal.com/features/mssql/article.php/3914366/Collecting-Performance-Metrics-Using-SQL-Server-DMV.htm
--Script by Gregory A. Larsen
DECLARE...
June 11, 2012 at 3:09 pm
Viewing 10 posts - 31 through 40 (of 40 total)