The tag has no wiki summary.

learn more… | top users | synonyms

5
votes
3answers
158 views

Load balancers and SQL backups

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 ...
1
vote
3answers
4k views

How do I backup the transaction log for a mirrored database in SQL Server?

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 ...
0
votes
2answers
520 views

Sql Server Simple Recovery - Backup selective file groups

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 ...
4
votes
1answer
180 views

SQL Server Restore from Backup, Just primary File Group

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. ...
0
votes
1answer
280 views

Flush MSSQL Express in Memory Data to Disk Without Service Shutdown

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 ...