SQL Clone
SQLServerCentral is supported by Redgate
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.


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, 1,376 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, 2,911 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, 1,801 reads

Posted in SQL Tact on 2 September 2011