question

Manvendra avatar image
Manvendra asked

backup for particulars tabels

Hi, Can we take the backup of particulars tables in a SQl Server database.? i.e I need to take backups of database but want to exclude one table as it will take more space is it possible in sql server ?? Any assistance is really appreciated.. Thanks
sql-server-2008sql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
In SQL Server you cannot backup only single table. However you can backup only a file or file group. So in case you have the the table on separate file group, then you can backup all the file groups except the one with the big table. For details see: [How to: Back Up Files and Filegroups (Transact-SQL)][1] [BACKUP (Transact-SQL)][2] [1]: http://msdn.microsoft.com/en-us/library/ms179401.aspx [2]: http://msdn.microsoft.com/en-us/library/ms186865.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.