Our production environments typically consists in 4-8 Apache web servers and 2 (My)SQL servers : Each web server is affiliated to one SQL server SQL servers have a circular replication setup All web ...
I have a large database, ~100 gig or so, and about 5 gigs of it is mission critical data, the rest, I could reload from a web service, so it's not crucial. Backing up that data is expensive, and not ...
Thankfully, this question is just a what-if, and I am not in an emergency right now. But I have created a file group in my database (sql server 2008), and moved some massive data tables over to it. ...
I am attempting to configure a MSSQL 2005 Express db to flush its in memory data to disk so that the data can be captured by using disk snapshot software. I have been unable to find any particular way ...
I have a mirrored database and am trying to perform a backup of the transaction log, but after it gets to 90% it just hangs and won't go any further. What is the correct method for backing up a DB ...