All Questions
2 questions
2
votes
0
answers
449
views
SQL Server 2008 R2 - Two Files Stuck In Restoring Status
Background: SQL Server 2008 R2 mirrored and clustered.
We recently failed over the databases via mirror and everything went smoothly. When it was time to do a differential backup, I got an error so I ...
1
vote
1
answer
1k
views
How many files should I create for one filegroup and 9 weekly partitions?
I have 9 weekly partitions on one filegroup. How many files do I need to create?
There are 3 tables containing 46 million, 16 million and 10 million rows.