filegroup backup
-
I have certain tables I need to backup
Can I use filegroup backup even if the tables already been created and have data? If yes, how? Alter?
I want to put the tables in the filegroup for backup.
Help..
-
I am sort of hashing this out in the Moving tables between filegroups thread.
Unfortunately, it depends on clustered indexes. You just can't do an Alter Table command.
Now here is the other question: Why not backup the whole database? Is it that large?
Just asking the dumb question.
----------------
Jim P.A little bit of this and a little byte of that can cause bloatware.
-
You can alter the table filegroup using SQL EM. Go in Table Design and right click for Properties. There you have a option to change the filegroup for that table.
You could change the filegroup for those tables and take a backup of that filegroup only. However, one piece of caution maintaining File/Filegroup backups in SQL Server in cumbersome. Before doing a File/Filegroup restore, you need to take a T-log backup which needs to be restored afer you restore the File/Filegroup. It is not advisable to keep File/Filegroup backups until and unless you are very confident about the backup/recovery procedures.
You could have a blend of Full database and T-log backups though. However, it all depends what kind of database you are running in what enviornment.
Hope this helps.
--Kishore
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply