Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database backup Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 6:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 5:38 AM
Points: 102, Visits: 312
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
Post #1497786
Posted Tuesday, September 24, 2013 6:40 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:47 AM
Points: 837, Visits: 2,460
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.
Post #1497816
Posted Tuesday, September 24, 2013 6:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
Yes.

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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1497817
Posted Tuesday, September 24, 2013 6:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 5:38 AM
Points: 102, Visits: 312
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
Post #1497820
Posted Tuesday, September 24, 2013 7:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
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.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1497826
Posted Tuesday, September 24, 2013 7:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 5:38 AM
Points: 102, Visits: 312
i am searching but its give me manually database backup actullay
Post #1497829
Posted Tuesday, September 24, 2013 7:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
Third result for "sql server script database backup":

Simple script to backup all SQL Server databases

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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1497834
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse