Re: Automated Backup

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Smith (laplas_at_gmail.com)
Date: 12/01/04

  • Next message: Ambros: "Re: About a Free MSDE manager" 
    Date: Tue, 30 Nov 2004 20:13:51 -0500

    You can try SQLExecMS from www.laplas-soft.com
    It allows to create maintenance plans for your databases.

    "James Proctor" <JamesProctor@discussions.microsoft.com> wrote in message
    news:C6DBD816-25C1-4A0E-8E78-60FAB18A6940@microsoft.com...
    > Hi there,
    >
    > I currently have a MSDE Server running with a number of databases on which
    > i
    > would like to backup daily and weekly at a certain time. Is there anyway
    > of
    > doing this?? At the moment ive just been using a simple line of code and
    > executing when i remeber to, but an automated system would be great. The
    > code
    > ive been using is:
    >
    > BACKUP DATABASE dbname TO DISK = 'C:\dbname.bak'
    >
    > Any help of links to sites that explain how todo this would be excellent!!
    >
    > James

  • Next message: Ambros: "Re: About a Free MSDE manager"

    Relevant Pages

    • Re: database log truncated, transaction log backup job failed
      ... I got it fixed by selecting the specific databases in the Maintenance plan. ... step that runs the transaction log dump". ... Unfortunately, I recall now, that maintenance plans do a good job of ... it seems like the only time you need to backup the transaction logs is ...
      (microsoft.public.sqlserver.tools)
    • Re: Sql 2005 cant update maintenance plans?
      ... I've added databases to maintenance plans and the newly added databases are ... It's more trouble than it was in SQL2K since you have to ... I created a couple of maintenance plans in Sql 2005 and they run fine. ... I edit them and make changes though, the changes seem to be saved but they ...
      (microsoft.public.sqlserver.tools)
    • Re: Maintenance PLan recommendation
      ... > week and I am examining the maintenance plans created by ... > tranlog backup steps and want to isolate them. ... 11 db's in one dbmp is no problem. ... i like to have a dbmp for "all user databases" and one for "system ...
      (microsoft.public.sqlserver.server)
    • RE: SQL 2005 Trans Log Backups Not Working
      ... If you're interested in an alternative to the Maintenance Plans you could ... I tried to recreate the backup maintenance plan for transaction ... I can "Select Databases" in the drop-down list. ... How can I get the transaction log backup plan to, well, work? ...
      (microsoft.public.sqlserver.setup)
    • Re: Databases
      ... I suggest making 2 maintenance plans. ... Databases and select All System Databases in the wizard. ... For Backups I also have the wizard put all backups ... > up 'master', everything is fine. ...
      (microsoft.public.sqlserver.server)