Back up Query help

Question

Back up Query help

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Balaji L Hall of Fame Points: 3067 More actions · Answer 1

Hi ,

Can someone please help me how to take 20% of backup from my OLTP db. Is there anyway to take only 20% backup in sql server 2000/2005?

Thanks,

Balaji L

pandeysharp Newbie Points: 9 More actions · Answer 2

Please give me a query to create a job on Sql server 2005 for taking a back up. I want to run the job when I would like.

Clive Strong SSChampion Points: 11222 More actions · Answer 3

By default, no, you can't set a backup size of 20% of the database. Well, not a command I have seen and to be honest, not one I'd every use! However, you can segment your database into various files/filegroups and back those up sepearately.

Clive Strong SSChampion Points: 11222 More actions · Answer 4

Pandeysharp,

To create a scheduled job, use sp_add_job and sp_add_jobstep. If you did want to run schedule the job, also look at sp_add_jobschedule.

You probably want to look at the syntax in BOL. It's very clear and easy to follow.

Adam Haines SSC-Insane Points: 23217 More actions · Answer 5

Please give me a query to create a job on Sql server 2005 for taking a back up. I want to run the job when I would like.

Create the backup in SSMS but do not execute it. Instead click at the top and generate to new query window.

Now go down to the jobs folder and right-click --> new and add a new step that executes tsql and paste the query generated. You can then click the schedule tab to schedule it.

My blog: http://jahaines.blogspot.com

Adam Haines SSC-Insane Points: 23217 More actions · Answer 6

Hi ,
Can someone please help me how to take 20% of backup from my OLTP db. Is there anyway to take only 20% backup in sql server 2000/2005?

Only with Filegroup backups. More can be found in BOL.

My blog: http://jahaines.blogspot.com