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

Archives: September 2011

New website, exciting future for BRSSUG

Just wanted to push out an announcement that the Baton Rouge SQL Server User Group has a new website.

www.brssug.org

We've got a great few months ahead of us with our buddies at the BR .net User Group!

October's meeting is on the topic of Change Data Capture (CDC) as…

Read more

0 comments, 700 reads

Posted in SQL Tact on 30 September 2011

Striped backups in SQL Server

Some DBA's don't realize that SQL server can perform a database backup that breaks up the files - stripes them - in a single command.  SQL can stripe the backup into an unlimited number of files, creating a multi-file backup set.



I got a request from a client to break…

Read more

1 comments, 1,206 reads

Posted in SQL Tact on 12 September 2011

Moving the SQL replication snapshot folder

I recently addressed an issue where a client server's data volume was getting dangerously tight on free space.  It contained data files (.mdf's) as well as the replication snapshot folder, which hosted dozens of publications.



While snapshots were set to be cleared out aggressively, a new snapshot on a large database could…

Read more

0 comments, 954 reads

Posted in SQL Tact on 2 September 2011