Change the owner of the job to a SQL service acct.

Yes, this relates to my other post about swapping out a drive. I need to move the files off the old drive, then back onto the new drive with the...

No history at all for any databases on the server ? It is possible to delete the backup history. Perhaps someone did ?

At my last company, were told that the new web app was going to be WAMP ... we didn't get to vote. I just took it as an opportunity to...

Detach, move, attach ..... good to go.

How about this ?

Bingo ! Thanks a lot !

Ian Ritchie (10/21/2008)

---

To quickly identify locks use Query Analyser and sp_who or sp_who2

If you have a couple of tables central to the transactions of a couple of users, then the...

Make sure the job is enabled AND that the schedule inside the job is enabled.

As suggested, look at your backup history to see what actually ran and when: For instance, you can run this:

[font="Courier New"]SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when type='D'...

Did you reboot ?

Lester Policarpio (10/12/2008)

---

Thank you for the inputs guys. When I received the error in my server i already checked the drive where in the mdf and ldf is and the...

http://support.microsoft.com/kb/224071

http://www.sqlservercentral.com/articles/Administering/movingsystemdatabasesachecklist/1608/

Do you have a link to any documentation where this has been published as best practice for SQL Server? I would like to review that for myself - since,...

If your FULLs take too long, perhaps do a differential(s) during the day to cut down on the number of transaction logs that would need to be restored.