Hi All,
I'm seeking feedback on a backup issue. I have several databases that I run full backups on nightly (simple recovery) using a SQL 2005 maintenance plan.
Each database has 1 or 2 tables that hold non-critical spam hit data. This data accounts for approximately half the database size and grows daily.
My question: Is there a simple way to skip / exclude 1 or 2 tables during a native SQL backup routine either via SQL maintenance plan of TSQL.
All help is greatly appreciated.
Thanks.
Rick B
Exclude a Table from SQL 2005 Backup Maintenance Plan
Hot Topic
- multiple-step ole db error
- Calling Store Procedures
- How do I make Newspaper Columns in RS
- CLR in SQL2005 with assembly containing dllimports
- Merge replication using wins mobile 5.0
- How to generate SP scripts
- Handle TEXT FIELDS in Recordset Using ASP
- MSDE - Start Databases
- Replication performing UPDATES as INSERTS and DELETES on the subscriber
- Pad Spaces in FFConnection properties?
SQL Server
- Updating empty Image field in existing SQL table record
- access datasource in script component
- Set Rectangle Size dynamically
- Interactive charts, etc.
- viewing closed conversations
- Replication from Sybase 12.5 to SQL Server 2000
- How to connect to SQL server 2005 from C# after default installation?
- Column Graph
- export to ccsv problem
- Data Transfer reported as succesfull BUT only one row is ever transfered!!
Exclude a Table from SQL 2005 Backup Maintenance Plan
Carl Dawson
Thanks Sunil and Boris. I guess I was leaning towards that way. THanks you for taking the time to reply.
Regards,
Rick Broider
JohnAskew
Partial Backups (link to it).
Regards,
Boris.
djperegrine
Have you considered moving this tables to their own file group. You can then skip backing up this file group. Other choice may to move these tables to another database
Thanks