Due to security reasons I cannot list the print statement here as it lists all the databases in the sql server. Plus how is that statement going to help you...

Have the maintenance plan delete any files older then 24 hours - this way any time you do a backup you will automatically delete the last backup since you are...

Run the SQL 2005 upgrade advisor if you are planning to do an in place upgrade.

Now getting the following error:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'name'.

Server: Msg 207, Level 16, State 1, Line 1

Invalid column name 'uid'.

Server: Msg 207, Level...

Ran it in SQL 2000, got the following error:

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'MAX'.

Server: Msg 137, Level 15, State 1, Line 6

Must...

No you do not have to. You might also want to select the option of removing inactive entries from the tran logs after every backup.

Why not just use the built in maintenance plan with SQL 2005 to do the backups....

Make sure you donot have any open transactions that are currently running that can lock out any shrink options for the tran log file.

And make sure you specific the interval you want the clean up task to execute on....daily, weekly and also provide the correct extension of the file that the clean task...

The login that you are using to connect to the database server doesnot have sufficient rights.

As a good disaster recovery option, you should always do a full backup of the system dbs at an interval that your organization is comfortable with, preferably on a daily...

Is there anyway we can make this work in SQL 2000. I need to run this on a SQL 2000 box.

Please advise.

Thank you.

Keep it going....great work 🙂

Thank you. It works now.

I get the following error:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '.'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '.'.

Msg 102, Level 15, State 1,...