Viewing 15 posts - 5,701 through 5,715 (of 9,726 total)
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...
June 20, 2011 at 6:48 am
It definitely sounds like someone renamed a folder and didn't bother to update the log shipping job.
June 20, 2011 at 6:46 am
GSquared (6/20/2011)
June 20, 2011 at 6:44 am
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...
June 20, 2011 at 6:39 am
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...
June 20, 2011 at 6:35 am
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.
June 20, 2011 at 6:33 am
Where are the ReportServer and ReportServerTempDB databases located?
June 20, 2011 at 6:27 am
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...
June 20, 2011 at 6:26 am
Ewan Hampson (6/20/2011)
SQL Server should have a health warning about system databases and backups
That's what the DBCC commands and the Alert system are for. You should only have to worry...
June 20, 2011 at 6:16 am
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.
June 20, 2011 at 5:54 am
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...
June 20, 2011 at 5:50 am
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....
June 20, 2011 at 5:47 am
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...
June 20, 2011 at 5:44 am
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...
June 20, 2011 at 5:43 am
george sibbald (6/15/2011)
June 20, 2011 at 5:39 am
Viewing 15 posts - 5,701 through 5,715 (of 9,726 total)