Eoin (12/2/2009)

---

I see a SPN error message in the posted sql logs, have you recently changed the permissions of the service accounts (or changed the accounts).

Also is the E drive...

Lynn Pettis (12/1/2009)

---

Okay, but looking at the error...

"TCP\IP only" ... our usual setting

I had, through the Services screen. I just tried again, through SQL...

I've rebooted several times, and the drives have been available. Not sure about drive availability when the problem first appeared.

The errors in post #4 came from the event log.

If SQL...

All the other databases are located on F, just the 1 problem database on E.

GilaMonster (12/1/2009)

---

Are you sure that the...

Here is the SQL Error Log (with some details made generic)

About 2/3 down there are errors about file location on "E" of one .MDF, But the file does exist in...

I don't know much about the settings .. where should I look ? I think the port is the default.

There are some errors showing after the reboot yesterday:

"Initiator failed to...

Maybe you can query restorehistory and join to backup tables using backup_set_id and restore_type to see the most recent restore. Too busy to dig any deeper right now.

What did you...

Why don't you use the new, easier email functionality ? sp_send_dbmail

xp_sendmail will be removed at some point, so probably not a good idea to use it if possible.

Make 10 stored procedures, then control & schedule through SQL.

I think you can avoid a snapshot if you have created the subscriber by another method. But you have a risk of data getting out of sync if you do...

The question is not just a backup plan, but the CORRECT plan.

Create a practice database for yourself, and put in sample inventory of things around your house (item #, price, qty ....). Think about how it should be organized. Write some...

There are 2 basic options

1) In Place Upgrade - Using the existing database, it is upgraded to a new version directly and replaces the old version.

2) Side-by-Side Upgrade - The...