Running multiple sql server 2005 instances on windows 2008.
Our Server guys changed the way that they back up the server (at the server level) and excluded all .ldf and .mdf files.
Needless to say when we recently went through a disaster recovery drill I had to uninstall and reinstall sql server (all intstances) before I could begin restoring databases.
I am wondering if I had made copies of the master, resource, msdb and model .mdf and .ldf files for each instance and then copied them into their correct directories for the DR drill if i could have avoided having to reinstall SQL Server? I don't have a server to test this on which is why I am asking....
How do others backup their servers hosting sql server?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…