You can do this by Maintenance Wizard or as follows with TSQL job:

SQLMAINT.EXE -D DATABASENAME -CkDB -CkAl -CkTxtAl -CkCat -UpdSts -BkUpDB D:\MSSQL\BACKUP\DATABASENAME\DB -BkUpMedia DISK -DelBkUps 1 -Rpt D:\MSSQL\BACKUP\DATABASENAME\Reports\DATABASENAME_Daily_Maint.rpt

OR You can...

Please check the syntax and options in BooksOnline for SQLMAINT.EXE.

You can do this by Maintenance Wizard or as follows:

SQLMAINT.EXE -D DATABASENAME -CkDB -CkAl -CkTxtAl -CkCat -UpdSts -BkUpDB D:\MSSQL\BACKUP\DATABASENAME\DB -BkUpMedia DISK -DelBkUps 1 -Rpt D:\MSSQL\BACKUP\DATABASENAME\Reports\DATABASENAME_Daily_Maint.rpt

OR You can just take the...

Did you change anything on 03/14/2003 or 03/13/2003?! Did you remove access to BUILTIN/Administrators on the SQL Server?! (if the problematic job you are asking is a SQL Agent Job).

...

This is completely strange to me now. When I did this test just now, the sizes are exact. I remember and I still have one of the old backup copy...

Thank You Allen.

Let me run both ways in parallel on a user database now. I will update the page.

Any Ideas on this?! Or if we get errors like this, what do we need to do?!

I have tried this in various Servers I have got, Which spans thru SQL Server 6.5, 7.0 and 2000. I see the result differences in all three versions.

Andy : I am sure Maintenance Plan is not using shrinkdb first. Because the database size is not changing. If we perform the same thing the next day, I see...

Thank You Bill. Thats the same way I am doing on the other servers. I jsut wanted to take extra coution and take Data directory backup as well atleast biweekly...

No. My question is different. Here is the scenario.

I have a new server coming on board with SQL2K on WIN2K. If we run a TAPE BACKUP from NT (to backup...

You can do this with Tasks in DTS. Even you can import an EXCEL sheet as well. You just need to define what cell goes to which field.

You can create...

Any thoughts?!

Thank You Andy.