February 9, 2010 at 4:20 pm
how to take the backup of the datbase excluding some tables.
February 9, 2010 at 4:25 pm
You can backup a database or a filegroup, but not at the table level.
You can organize your tables into filegroups if you need the ability to only backup certain groups of tables.
February 9, 2010 at 4:33 pm
thanks..........
can you please explain clearly..........
February 9, 2010 at 4:55 pm
Well, let's say you have a database with 3 tables: TableA, TableB, and TableC. Tables A&B contain transactional data and changes quite frequently so you want to backup these tables on a regular basis, daily or more often. TableC is a huge inventory description table that rarely changes but it is so large that it lengthens the backup time when a full database backup is used.
Given that scenario, you could set up your database so that it contains 2 file groups: FileGroup1 and FileGroup2. Place TableA and TableB in FileGroup1 and TableC in FileGroup2. For daily backups (or more regularly) you would backup FileGroup1. Every week/month/quarter or whenever you feel the need, you could backup FileGroup2 and capture the changes for TableC.
Make sense? If not, you may want to read up on files/filegroups in BOL as well as the 'Files or filegroups' section under backups.
February 9, 2010 at 5:49 pm
thanks..........
there is only one primary filegroup in my database.
i have created one file group FG1.
how to move tables to FG1.
February 9, 2010 at 5:52 pm
You should be aware that you cannot use a file or filegroup backup to recover a table to a different point in time than the rest of the database.
February 9, 2010 at 6:01 pm
yes, i need a backup of the database excluding some tables.
February 9, 2010 at 6:09 pm
Here is an article that discusses how to move tables to filegroups
http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 9, 2010 at 6:09 pm
so how to move the table to another filegroup?
February 9, 2010 at 6:11 pm
Read the article I posted.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 9, 2010 at 6:18 pm
that url is not opening.
February 9, 2010 at 6:22 pm
charipg (2/9/2010)
that url is not opening.
Are you still having problems opening the article? Just wondering, as I was able to click on the url and the article opened just fine.
Were you getting an error of some kind?
February 9, 2010 at 6:32 pm
yes, i am still not able to open the url.
February 9, 2010 at 6:54 pm
Are you getting an error of any type?
February 9, 2010 at 6:58 pm
Try a copy and paste to a new browser window. Also, did you receive an error message?
Here is an additional article.
http://decipherinfosys.wordpress.com/2007/08/14/moving-tables-to-a-different-filegroup-in-sql-2005/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply