sql server msde: Automated Backup -- sql server msde

You're in the

sql server msde

group:

Automated Backup

James Proctor
11/30/2004 9:35:02 AM

sql server msde:

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!!

Re: Automated Backup

John Smith
11/30/2004 8:13:51 PM

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

[quoted text, click to view]

Re: Automated Backup

Greg Low [MVP]
12/1/2004 7:19:27 AM

Hi James,

You need to schedule a job with the sql agent. First, make sure it is
running (it is a separate service). Then take a look at sp_addjob and
sp_addjobstep.

If that sounds messy, the MSDE Manager utility at our web site has options
to do that for you and is free for personal use.

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn