Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: SQL Server Logins ???

    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...

  • RE: SQL Server Logins ???

    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'"

  • RE: SQL Server Logins ???

    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...

  • RE: Backup plan goes wrong

    Thanks guys - the manual backup works well for me...

    instead of adding a 'dump device' I decided to go with this:

    declare @backup as...

  • RE: Backup plan goes wrong

    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...

  • RE: Backup plan goes wrong

    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...

  • RE: Backup plan goes wrong

    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...

Viewing 7 posts - 1 through 7 (of 7 total)