2
votes
3answers
201 views

Replication or?

Recently, we have been hammered by Google Bots and all kinds of other bots( 60% of the website traffic that we experience on an average are from Bots. We are trying to segment out the Google Bot ...
2
votes
2answers
1k views

Schedule Recreate Snapshot and Reinitialize Subscriptions - SQL 2005

Monthly I have to generate a new snapshot for replication and reinitialize subscriptions in SQL 2005. I would really like to automate and schedule this, but I'm not having much luck discovering how. ...
2
votes
2answers
203 views

SQL server 2005 Checkdb - no room for snapshot files

I have a 2Tb+ SAP database with 8 datafiles, the first files have grown to fill the available disk space on our HP EVA5000, and the growth is now on the new files. We upgraded SQL from SQL server 2000 ...
1
vote
1answer
720 views

Create a SQL Server full backup without affecting maintenance plan?

We use a centralized SQL Server 2005 server for web development. The server has a maintenance plan to take a full backup each Sunday and incremental backups on all other nights. All databases use ...
2
votes
1answer
1k views

Backing up SQL NetApp Snapshots using TSM

In our environment we have a 3 node SQL 2005 Cluster which is on NetApp storage. We are currently using SMSQL (NetApp SnapManager for SQL) to take Snapshot backups of the data. This works great, but ...