How can I schedule backup in SQL Server 2000 for ALL databases?
With SQL Server 2005 I can create maintenance plan to do this,
but in the 2000 version I don′t know.
thanks!!!!You can do the same thing in SQL Server 2000. Create a new maintenance plan, select All databases, specify backup options and a schedule, complete the wizard. It will create a job that will backup all of the databases using the options that you specified.|||
Have you tried one of the many different online backup solutions for sql server? there's one from
4backuponline.com that works with sql server and it has been working beatiful for me for that last couple of months. You set it up once and you can forget about it.|||An advice though, if you'll use 3rd party backup software for SQL Server, better choose a tool that performs the backup via execution of T-SQL queries.
It is a more durable solution
No comments:
Post a Comment