Viewing 15 posts - 5,701 through 5,715 (of 9,722 total)
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
Hashbytes seems overly complicated to me as well.
June 20, 2011 at 5:14 am
Steve Jones - SSC Editor (6/17/2011)
June 20, 2011 at 5:07 am
GilaMonster (6/17/2011)
1) Finding out the backup is damaged and unrestorable right after making it, when you can make another
2) Finding out the backup is damaged after the...
June 20, 2011 at 5:04 am
paul.knibbs (6/20/2011)
June 20, 2011 at 5:01 am
Viewing 15 posts - 5,701 through 5,715 (of 9,722 total)