April 16, 2003 at 4:50 pm
I have a back job schduled for everyday,but its not working from 3/14/2003.How to enable the script to run again.
April 16, 2003 at 4:53 pm
Is it a SQL Agent job that runs the script?
Or something else. Why is it currently not working?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
April 16, 2003 at 8:11 pm
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).
.
April 17, 2003 at 4:49 am
anyway,If i want to schedule a back up for the whole database what should i do in the enterprise manager.
Can u please tell me how to schedule the process..
Thanks in advance
April 17, 2003 at 5:44 am
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 backup as follows:
SQLMAINT.EXE -D DATABASENAME -BkUpDB D:\MSSQL\BACKUP\DATABASENAME\DB -BkUpMedia DISK -DelBkUps 1 -Rpt D:\MSSQL\BACKUP\DATABASENAME\Reports\DATABASENAME_Daily_Maint.rpt
.
April 17, 2003 at 5:47 am
Please check the syntax and options in BooksOnline for SQLMAINT.EXE.
.
April 17, 2003 at 5:52 am
Have you created a dump device (sp_addumpdevice)? That's the first step.
Next, go to Enterprise Manager, expand your server, expand Management, expand SQL Server Agent, right click on JOBS and select New Job. Fill out the information. When you get to STEPS, just create a new step, select your database from the drop down list and then type your BACKUP command in the window.
Refer to the BOL for more information.
-SQLBill
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply