Database backup

Question

Database backup

immaduddinahmed

Ten Centuries

Points: 1375
More actions
September 24, 2013 at 6:01 am

#149924

hello,
i want to take a sql server 2005 database backup on task schedule every 1 hour is that possible.
please help me out.
thanks
immad

Viewing 7 posts - 1 through 6 (of 6 total)

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

adb2303 SSCertifiable Points: 7588 More actions · Answer 1

you want to take a full backup every hour? How come?! Are you aware of differential/tlog backups?

You can create a SQL Server job to execute any task every hour... just create a maintenance plan, tsql script or something to back up the database in question. Then change the job schedule that executes that task.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Yes.

You can script it out and run the script every hour with SQL Server Agent, or you can create a maintenance task.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

immaduddinahmed Ten Centuries Points: 1375 More actions · Answer 3

please provide me the script i have sql server 2005

and this is the info

Microsoft SQL Server Management Studio Express-----------9.00.2047.00

Microsoft Data Access Components (MDAC)-----------------2000.085.1132.00 (xpsp.080413-0852)

Microsoft MSXML------------------------------------------2.6 3.0 4.0 5.0 6.0

Microsoft Internet Explorer---------------------------------6.0.2900.5512

Microsoft .NET Framework---------------------------------2.0.50727.1433

Operating System-----------------------------------------5.1.2600

thanks in advance

immad

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 4

I'm pretty sure if you google around for a bit, you can find thousands of scripts on how to take a backup on SQL Server.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

immaduddinahmed Ten Centuries Points: 1375 More actions · Answer 5

i am searching but its give me manually database backup actullay

immad

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

Third result for "sql server script database backup":

Simple script to backup all SQL Server databases[/url]

If you're uncomfortable with backup scripts, you can always try a maintenance plan.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP