If you've attempted a design and failed, please post the DDL code and data sample so we can point out where your errors are. We'll be happy to help you...

If it's the same database each time, why not create a job for the restore, with the login fix as a separate step, and then give the Dev permissions to...

It definitely sounds like someone renamed a folder and didn't bother to update the log shipping job.

GSquared (6/20/2011)

---

There are ways around the storage limit, but they're technically a violation of the license agreement, and that's a legal violation that can get your business in trouble (like...

The database is working fine, but are you positive the file / filegroup is online?

EDIT: This article is for R2, but it almost mirrors the BOL 2005 entry on File...

If you're reaching your data limit, why would you be questioning how to increase the memory size? Data size and memory size are two different things and should be treated...

It definitely sounds to me like someone is doing something, like changing the recovery model back and forth or restoring the database, both of which can break the LSN.

Where are the ReportServer and ReportServerTempDB databases located?

Other workarounds include setting up the Alert system for errors x, y, and z. But you seem married to your script. And I don't know of any singular system db...

That's what the DBCC commands and the Alert system are for. You should only have to worry...

Also, check and see how often your job log clears itself out. That would be the reason why you're not seeing a history on the job.

Check the Configuration Manager for SQL Server. Someone may have turned off Named Pipes as a protocol.

EDIT: Also, check the box that the application is running on. Did someone turn...

So far as I know, there is no way to prevent it. Single User mode is used to prevent additional people from gaining access while certain maintenance activities are occurring....

Let's start from the beginning. Why do you want to write a script to do this?

Why can't you just have it read the most recent error log on each...

What Suresh didn't tell you is that databases upgraded to SQL 2005 can experience invalid page and row counts in the system catalog views. DBCC UpdateUsage corrects those counts.

However, if...