Viewing 7 posts - 1 through 7 (of 7 total)
Thanks guyz, I guess I don't want to do that, as I am actually using the sa login to maintain the db's via the enterprize manager.
I think I'll have to...
June 28, 2006 at 1:39 am
how do i revoke sysadmin role from sa, when ever i try to do so it gives me an error "can not use the reserved user or role name 'sa'"
June 27, 2006 at 7:23 am
yes, unfortunately I wasn't in the company when the DB was created and they created a few DB's under the main sa login, which is now the owner and...
June 27, 2006 at 4:18 am
Thanks guys - the manual backup works well for me...
instead of adding a 'dump device' I decided to go with this:
declare @backup as...
May 23, 2006 at 1:57 am
Cool
I just don't know how to create a backup step in a job...
Can you show me the code you use for the backup?
I guess you're executing some stored procedure???
How does...
May 22, 2006 at 8:02 am
Yes I did,
I also got rid of all the extra stuff, I've asked it not to Varify or backup anything else also not to optimize or minimize.. etc
So there...
May 22, 2006 at 2:02 am
ok...
got rid of the transact log backups and left only one DB to back up.
the job has one step in it called step1 when it fails it comes up...
May 19, 2006 at 6:51 am
Viewing 7 posts - 1 through 7 (of 7 total)