Post reply

SQL SERVER 2005 Express,Backup auto everyday

  • March 8, 2010 at 8:19 pm

    #219769

    i use SQL Server 2005 Express.i want to backup auto my database everyday.

    how can i do it?

    I'm new with SQL Server,please tell me step by step(easy for understand)

    Thank you so much

  • March 9, 2010 at 12:36 am

    #1130479

    You cannot automate database backups using Express Edition as you cant find SQL server Agent to create or schedule.

    Cheers,
    - Win.

    " Have a great day "

  • March 9, 2010 at 12:42 am

    #1130483

    It's possible to automate backups on SQL Express, just not with SQL Agent because it's not included. Some people use Windows Scheduler, some use 3rd party scheduling tools. I'd suggest starting with windows scheduler

    See

    http://support.microsoft.com/default.aspx/kb/162294

    http://www.mssqltips.com/tip.asp?tip=1486

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 9, 2010 at 1:10 am

    #1130489

    Agreed..

    I was talking about only SQL Express edition.

    Windows server is the option we can use, as Gail said.

    - Win.

    Cheers,
    - Win.

    " Have a great day "

  • March 9, 2010 at 9:54 am

    #1130763

    I use a batch file that has the necessary steps for the backup process and then schedule the same with the Windows scheduler

  • July 16, 2011 at 1:02 pm

    #1353875

    SQL Server and FTP will let you schedule backups. You can also save your backups in a remote location on your LAN or FTP sites, compression and encryption is also available.

    Version 6.0 provides some interesting advanced options such as differential and transaction log backups

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

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