Viewing 4 posts - 1 through 4 (of 4 total)
Please paste here what the step1 does ?
Jayesh
October 21, 2005 at 3:22 am
#599041
You can get this info from the "command" column of "sysjobsteps" table
October 21, 2005 at 3:06 am
#599038
Can I run a job to do a transaction log backup whilst the database is up and running and being used?
YES. Provided your database is in Full/Bulk Logged Recovery...
October 21, 2005 at 2:56 am
#599036
If still you are not able to do the RESTORE...
Try putting in single user mode using NO_WAIT
ALTER DATABASE pubs RESTRICTED_USER/SINGLE_USER WITH NO_WAIT
October 21, 2005 at 2:46 am
#599034