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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 6:51 AM
Points: 99, Visits: 301
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 1:52 AM
Points: 796, Visits: 2,354
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: Today @ 6:53 AM
Points: 12,228, Visits: 9,203
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 6:51 AM
Points: 99, Visits: 301
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: Today @ 6:53 AM
Points: 12,228, Visits: 9,203
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 6:51 AM
Points: 99, Visits: 301
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: Today @ 6:53 AM
Points: 12,228, Visits: 9,203
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