Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2013

Adding new data files to a log shipped database

I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site, and some new data files needed to be added to the database.

Mistake #1: The drive volumes on the DR server are not configured the same as the primary site. Read more

0 comments, 1,001 reads

Posted in A Discussion of SQL Server-Related Topics on 21 January 2013

T-SQL Tuesday #38 – Standing Firm

This month’s T-SQL Tuesday is hosted by Jason Brimhall. Being as this is January, lots of people are making New Year’s resolutions. Well, Jason doesn’t want to hear about that… but he does want to know how you have stood firm by a story that utilizes “resolve”, “resolute” or “resolution”. Read more

1 comments, 264 reads

Posted in A Discussion of SQL Server-Related Topics on 8 January 2013