sql server new users: SQL 2005 Express: Scheduling Backups -- sql server new users

You're in the

sql server new users

group:

SQL 2005 Express: Scheduling Backups

Ed Warren
12/31/2005 4:20:01 AM

sql server new users:

I want to backup a SqlServer Database on a schedule (database:: MyData,
(nightly)). It appears you can do this using the management wizard in SQL
2005 standard but not in Express. Is there a work around for SQL Express?

Thanks

Ed Warren

Re: SQL 2005 Express: Scheduling Backups

Ed Warren
12/31/2005 6:13:07 AM

Ok, I found a reference on the Microsoft Web that answered the question.
Gotta do it using transact-SQL.

Thanks.

Ed Warren

[quoted text, click to view]

Re: SQL 2005 Express: Scheduling Backups

Ed Warren
12/31/2005 1:07:57 PM

Thanks for the links, they look like a lot of hard work on your part and
full of good information

Ed Warren

[quoted text, click to view]

Re: SQL 2005 Express: Scheduling Backups

Jasper Smith
12/31/2005 3:26:22 PM

You can also have a look at

Automating Database maintenance in SQL 2005 Express Edition Part II
http://www.sqldbatips.com/showarticle.asp?ID=29

Automating Database maintenance in SQL 2005 Express Edition Part I
http://www.sqldbatips.com/showarticle.asp?ID=27

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.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 new users group.

home · blog · groups

Questions? Comments? Contact the dn