-
SQLMAINT.EXE -- Returns only the switches
Hi,
I am trying to run the following:
SQLMAINT.EXE -USA -P -S abc -D db1 -CkDB -Rpt c:\log_backup.rpt -DelTxtRpt 1days
But it simply returns the
SQLMaint switches and doesn't run the actual -CkDB?
Do I need to register any DLL to make this work ?
Thanks in advance,
-
Did you check .rpt file for details? If you just want to check db, you can run 'dbcc checkdb' instead.
-
It doesn't even create the file.
I need to use SQL maint to configure transaction backup in a batch file, Which later I would tie in to AutoSys Scheduler for Alerts.
Please help!
-
Then try create maintenance plan in enterprise manager.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|