Backup single table

FAQ

Profile

Backup single table

Database Help (Home) -> Server

Next: sql job agent

Author

Message

FARRUKH

External

Since: Jan 22, 2008
Posts: 18

(Msg. 1) Posted: Wed Apr 09, 2008 10:27 am Post subject: Backup single table Archived from groups: microsoft>public>sqlserver>server (more info?)

I would like to take the backup of only 15 tables out of 800 tables and 8 stored procedures out of 90. The database is very huge and might take few hours to take full database backup is there anyway I can take backup only selected tables and stored procedures? I have SQL Server 2000 running. thanks Farrukh >> Stay informed about: Backup single table

Tom Moreau

External

Since: Apr 21, 2004
Posts: 502

(Msg. 2) Posted: Wed Apr 09, 2008 1:39 pm Post subject: Re: Backup single table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

If you will regularly be backing up certain tables, then consider placing them into their own filegroup and then backing up that filegroup. As for stored procs, you can use Enterprise Manager to script them. As a best practice, you should have your scripts in version control outside of your SQL Server. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "FARRUKH" wrote in message I would like to take the backup of only 15 tables out of 800 tables and 8 stored procedures out of 90. The database is very huge and might take few hours to take full database backup is there anyway I can take backup only selected tables and stored procedures? I have SQL Server 2000 running. thanks Farrukh >> Stay informed about: Backup single table

FARRUKH

External

Since: Jan 22, 2008
Posts: 18

(Msg. 3) Posted: Wed Apr 09, 2008 1:39 pm Post subject: Re: Backup single table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

I dont get this request daily. Actually this is the first time i get this request. I dont have any script. would you like to share ur script? thanks "Tom Moreau" wrote: > If you will regularly be backing up certain tables, then consider placing > them into their own filegroup and then backing up that filegroup. As for > stored procs, you can use Enterprise Manager to script them. As a best > practice, you should have your scripts in version control outside of your > SQL Server. > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > SQL Server MVP > Toronto, ON Canada > https://mvp.support.microsoft.com/profile/Tom.Moreau > > > "FARRUKH" wrote in message > > I would like to take the backup of only 15 tables out of 800 tables and 8 > stored procedures out of 90. The database is very huge and might take few > hours to take full database backup > > is there anyway I can take backup only selected tables and stored > procedures? I have SQL Server 2000 running. > > thanks > > Farrukh > > > >> Stay informed about: Backup single table

Tom Moreau

External

Since: Apr 21, 2004
Posts: 502

(Msg. 4) Posted: Wed Apr 09, 2008 2:33 pm Post subject: Re: Backup single table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

There is no script here. Just right-click on the DB, click on All Tasks->generate SQL script. As for the filegoups, you are looking at a fair bit of work, since you now need to migrate your existing tables to this filegroup, and that's a rebuild of those tables. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "FARRUKH" wrote in message I dont get this request daily. Actually this is the first time i get this request. I dont have any script. would you like to share ur script? thanks "Tom Moreau" wrote: > If you will regularly be backing up certain tables, then consider placing > them into their own filegroup and then backing up that filegroup. As for > stored procs, you can use Enterprise Manager to script them. As a best > practice, you should have your scripts in version control outside of your > SQL Server. > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > SQL Server MVP > Toronto, ON Canada > https://mvp.support.microsoft.com/profile/Tom.Moreau > > > "FARRUKH" wrote in message > > I would like to take the backup of only 15 tables out of 800 tables and 8 > stored procedures out of 90. The database is very huge and might take few > hours to take full database backup > > is there anyway I can take backup only selected tables and stored > procedures? I have SQL Server 2000 running. > > thanks > > Farrukh > > > >> Stay informed about: Backup single table

Tibor Karaszi

External

Since: Jan 29, 2004
Posts: 1559

(Msg. 5) Posted: Wed Apr 09, 2008 9:52 pm Post subject: Re: Backup single table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

> As for the filegoups, you are looking at a fair bit of work, since you now > need to migrate your existing tables to this filegroup, and that's a rebuild > of those tables. .... also, it isn't obvious how to get a backup of a filegroup available, unless you also have backup of the rest of the database (which makes the filegroup backup kind of ... moot). In short, filegroup backup should only be done with a very good understanding about backup in SQL Server and what it does and does not give you. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Tom Moreau" wrote in message > There is no script here. Just right-click on the DB, click on All > Tasks->generate SQL script. > > As for the filegoups, you are looking at a fair bit of work, since you now > need to migrate your existing tables to this filegroup, and that's a rebuild > of those tables. > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > SQL Server MVP > Toronto, ON Canada > https://mvp.support.microsoft.com/profile/Tom.Moreau > > > "FARRUKH" wrote in message > > I dont get this request daily. Actually this is the first time i get this > request. I dont have any script. would you like to share ur script? thanks > > "Tom Moreau" wrote: > >> If you will regularly be backing up certain tables, then consider placing >> them into their own filegroup and then backing up that filegroup. As for >> stored procs, you can use Enterprise Manager to script them. As a best >> practice, you should have your scripts in version control outside of your >> SQL Server. >> >> -- >> Tom >> >> ---------------------------------------------------- >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS >> SQL Server MVP >> Toronto, ON Canada >> https://mvp.support.microsoft.com/profile/Tom.Moreau >> >> >> "FARRUKH" wrote in message >> >> I would like to take the backup of only 15 tables out of 800 tables and 8 >> stored procedures out of 90. The database is very huge and might take few >> hours to take full database backup >> >> is there anyway I can take backup only selected tables and stored >> procedures? I have SQL Server 2000 running. >> >> thanks >> >> Farrukh >> >> >> > > >> Stay informed about: Backup single table

"Greg D. Moore

External

Since: Jan 13, 2008
Posts: 48

(Msg. 6) Posted: Fri Apr 11, 2008 10:09 pm Post subject: Re: Backup single table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

In a case like this, BCP MIGHT be a workable solution. "Tibor Karaszi" wrote in message >> As for the filegoups, you are looking at a fair bit of work, since you >> now >> need to migrate your existing tables to this filegroup, and that's a >> rebuild >> of those tables. > > ... also, it isn't obvious how to get a backup of a filegroup available, > unless you also have backup of the rest of the database (which makes the > filegroup backup kind of ... moot). In short, filegroup backup should only > be done with a very good understanding about backup in SQL Server and what > it does and does not give you. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Tom Moreau" wrote in message > >> There is no script here. Just right-click on the DB, click on All >> Tasks->generate SQL script. >> >> As for the filegoups, you are looking at a fair bit of work, since you >> now >> need to migrate your existing tables to this filegroup, and that's a >> rebuild >> of those tables. >> >> -- >> Tom >> >> ---------------------------------------------------- >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS >> SQL Server MVP >> Toronto, ON Canada >> https://mvp.support.microsoft.com/profile/Tom.Moreau >> >> >> "FARRUKH" wrote in message >> >> I dont get this request daily. Actually this is the first time i get this >> request. I dont have any script. would you like to share ur script? >> thanks >> >> "Tom Moreau" wrote: >> >>> If you will regularly be backing up certain tables, then consider >>> placing >>> them into their own filegroup and then backing up that filegroup. As >>> for >>> stored procs, you can use Enterprise Manager to script them. As a best >>> practice, you should have your scripts in version control outside of >>> your >>> SQL Server. >>> >>> -- >>> Tom >>> >>> ---------------------------------------------------- >>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS >>> SQL Server MVP >>> Toronto, ON Canada >>> https://mvp.support.microsoft.com/profile/Tom.Moreau >>> >>> >>> "FARRUKH" wrote in message >>> >>> I would like to take the backup of only 15 tables out of 800 tables and >>> 8 >>> stored procedures out of 90. The database is very huge and might take >>> few >>> hours to take full database backup >>> >>> is there anyway I can take backup only selected tables and stored >>> procedures? I have SQL Server 2000 running. >>> >>> thanks >>> >>> Farrukh >>> >>> >>> >> >> > -- Greg Moore SQL Server DBA Consulting Remote and Onsite available! Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html >> Stay informed about: Backup single table

tarun mukherjee

External

Since: Nov 10, 2010
Posts: 1

(Msg. 7) Posted: Wed Nov 10, 2010 8:43 am Post subject: Re: Backup single table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

I would like to take the backup of only 15 tables out of 800 tables and 8 stored procedures out of 90. The database is very huge and might take few hours to take full database backup is there anyway I can take backup only selected tables and stored procedures? I have SQL Server 2000 running. thanks > On Wednesday, April 09, 2008 1:27 PM farrscorpio7 wrote: > I would like to take the backup of only 15 tables out of 800 tables and 8 > stored procedures out of 90. The database is very huge and might take few > hours to take full database backup > > is there anyway I can take backup only selected tables and stored > procedures? I have SQL Server 2000 running. > > thanks > > Farrukh >> On Wednesday, April 09, 2008 1:39 PM Tom Moreau wrote: >> If you will regularly be backing up certain tables, then consider placing >> them into their own filegroup and then backing up that filegroup. As for >> stored procs, you can use Enterprise Manager to script them. As a best >> practice, you should have your scripts in version control outside of your >> SQL Server. >> >> -- >> Tom >> >> ---------------------------------------------------- >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS >> SQL Server MVP >> Toronto, ON Canada >> https://mvp.support.microsoft.com/profile/Tom.Moreau >> >> >> "FARRUKH" wrote in message >> >> I would like to take the backup of only 15 tables out of 800 tables and 8 >> stored procedures out of 90. The database is very huge and might take few >> hours to take full database backup >> >> is there anyway I can take backup only selected tables and stored >> procedures? I have SQL Server 2000 running. >> >> thanks >> >> Farrukh >>> On Wednesday, April 09, 2008 2:30 PM farrscorpio7 wrote: >>> I dont get this request daily. Actually this is the first time i get this >>> request. I dont have any script. would you like to share ur script? thanks >>> >>> "Tom Moreau" wrote: >>>> On Wednesday, April 09, 2008 2:33 PM Tom Moreau wrote: >>>> There is no script here. Just right-click on the DB, click on All >>>> Tasks->generate SQL script. >>>> >>>> As for the filegoups, you are looking at a fair bit of work, since you now >>>> need to migrate your existing tables to this filegroup, and that's a rebuild >>>> of those tables. >>>> >>>> -- >>>> Tom >>>> >>>> ---------------------------------------------------- >>>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS >>>> SQL Server MVP >>>> Toronto, ON Canada >>>> https://mvp.support.microsoft.com/profile/Tom.Moreau >>>> >>>> >>>> "FARRUKH" wrote in message >>>> >>>> I dont get this request daily. Actually this is the first time i get this >>>> request. I dont have any script. would you like to share ur script? thanks >>>> >>>> "Tom Moreau" wrote: >>>>> On Wednesday, April 09, 2008 3:52 PM Tibor Karaszi wrote: >>>>> ... also, it isn't obvious how to get a backup of a filegroup available, unless you also have backup >>>>> of the rest of the database (which makes the filegroup backup kind of ... moot). In short, filegroup >>>>> backup should only be done with a very good understanding about backup in SQL Server and what it >>>>> does and does not give you. >>>>> >>>>> -- >>>>> Tibor Karaszi, SQL Server MVP >>>>> http://www.karaszi.com/sqlserver/default.asp >>>>> http://sqlblog.com/blogs/tibor_karaszi >>>>> >>>>> >>>>> "Tom Moreau" wrote in message >>>>> >>>>>> On Friday, April 11, 2008 10:09 PM Greg D. Moore \(Strider\) wrote: >>>>>> In a case like this, BCP MIGHT be a workable solution. >>>>>> >>>>>> >>>>>> "Tibor Karaszi" wrote in >>>>>> message >>>>>> >>>>>> -- >>>>>> Greg Moore >>>>>> SQL Server DBA Consulting Remote and Onsite available! >>>>>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html >>>>>> Submitted via EggHeadCafe >>>>>> Fill out blank PDF form online and stream to browser with iTextSharp >>>>>> http://www.eggheadcafe.com/tutorials/aspnet/a5e1109d-03bc-4e6b-a904-af...5f336cd >> Stay informed about: Backup single table

Display posts from previous:

Related Topics:

Join to a single date rate table? - Given an exchange rate table like: Create Table XRates ( EffectiveDate smalldatetime, FromCury char(3), ToCury char(3), Rate float ) and Transaction table like Create Table Trans ( TranDate smalldatetime, TranCury char(3), TranAmt float ) What would b...

Help in Table level restore/backup Options - I am currently doing a project on MS SQL Server 2005 where I am in need of table level backup/restore. I know about FILEGROUP. But in our project using FILEGROUP is not feasible. As far as I know MS SQL Server 2005 does not support Table level restor...

How to Use Backup Exec to Backup SQL Server 2005 Database - As some observers will know from my previous posts, I have a 2-node Windows cluster, and it is running SQL Server 2005 Standard Edition in an active-passive mode. I want to run periodic backup from the passive server using Backup Exec. Does anyone..

Single CPU Maxed Out.. - Hi We have an oltp server that playing up.. ..it's 64bit sql 2005 with sp2 applied. The server is one of 8 identically built subscribers (Both Hardware & Software configurations are identical across all 8), and has one of the lowest loads of t...

audit single user mode - Any way to audit when/and by whom a DB has been changed to single user mode? We have a couple of DB's that are being locked, and it appears to be some process. Nothing shows up in SQL logs / event logs indicating the change. Any way I can turn on..

	Database Help (Home) -> Server	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum