|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2005 Express Database BackupI was just saddled with SQL Server 2005 Express after having SQL Server
MSDE. I was able to use Enterprise Manager to schedule database backups automatically. Is there a tool that works with SQL Server 2005 Express that allows me to automatically schedule database optimizations, data and index checks, backup database and backup transaction logs? Is that tool a free downloadable one? I would rather have a free downloadable one as opposed to having to purchase one. I looked into SQL Server Management Studio Express and I do not see anything there that will accomplish that. Thanks. -- Janis Systems Analyst
http://sqldbatips.com/showarticle.asp?ID=27
--
Show quote
Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Janis" <Ja***@discussions.microsoft.com> wrote in message
news:2FF42E11-F0D7-4427-8D76-515F0E0A303E@microsoft.com... > I was just saddled with SQL Server 2005 Express after having SQL Server > MSDE. I was able to use Enterprise Manager to schedule database backups > automatically. > Is there a tool that works with SQL Server 2005 Express that allows me to > automatically schedule database optimizations, data and index checks, backup > database and backup transaction logs? Is that tool a free downloadable one? > I would rather have a free downloadable one as opposed to having to purchase > one. > I looked into SQL Server Management Studio Express and I do not see > anything there that will accomplish that. > Thanks. > -- > Janis > Systems Analyst And also http://sqldbatips.com/showarticle.asp?ID=29 which has had more work
done on it recently and has better support for things like disabled indexes. I will update the TSQL version when I get some time :-) Show quote "Janis" <Ja***@discussions.microsoft.com> wrote in message news:2FF42E11-F0D7-4427-8D76-515F0E0A303E@microsoft.com... > I was just saddled with SQL Server 2005 Express after having SQL Server > MSDE. I was able to use Enterprise Manager to schedule database backups > automatically. > Is there a tool that works with SQL Server 2005 Express that allows me to > automatically schedule database optimizations, data and index checks, > backup > database and backup transaction logs? Is that tool a free downloadable > one? > I would rather have a free downloadable one as opposed to having to > purchase > one. > I looked into SQL Server Management Studio Express and I do not see > anything there that will accomplish that. > Thanks. > -- > Janis > Systems Analyst  |
|||||||||||||||||||||||
Other interesting topics