Database backup

  • 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

  • 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.

  • 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

  • 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

  • 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

  • i am searching but its give me manually database backup actullay

    immad

  • 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

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

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