Viewing 15 posts - 7,921 through 7,935 (of 49,571 total)
Grant Fritchey (9/4/2014)
You never know. I get stumped all the time. That's why Gail's here.
Wha?
Well, at least I have a purpose in life...
September 5, 2014 at 2:47 am
AppSup_dba (9/4/2014)
Error log
During undoing of a logged operation in database '', an error occurred at log record ID (xx)
Database was shutdown due to...
September 5, 2014 at 2:29 am
The transaction log is full due to replication.
If you have transactional replication configured, make sure the log reader is running.
September 5, 2014 at 2:25 am
September 4, 2014 at 7:46 am
To start with, don't use multi-statement table-valued functions. They're notorious performance problems, especially when joined to other tables. That's because of the lack of stats on the table variables.
Try converting...
September 4, 2014 at 7:30 am
LadyDardar (9/4/2014)
September 4, 2014 at 6:38 am
LadyDardar (9/4/2014)
It was recommended to switch to either simple or bulk.
Probably recommended by someone who doesn't know what recovery models do...
Does your system require point-in-time recovery in the case...
September 4, 2014 at 6:09 am
LadyDardar (9/4/2014)
i'm concerned that I run the risk of corrupting my db everything I switch from full recovery to simple mode.
Um....
SQL does not corrupt its own databases. Corruption is...
September 4, 2014 at 6:05 am
Every single data modification is applied to the secondary.
September 4, 2014 at 4:48 am
AppSup_dba (9/4/2014)
4078 transactions rolled forward in database 'database' (9). This is an informational message only. No user action is required.
Recovery of database 'database' (9) is 4% complete (approximately 146199...
September 4, 2014 at 2:36 am
It shouldn't be, I did say that.
Is the mirroring failing over?
Are there any useful messages in the error log?
Is the log on the mirror side also filling up?
Are you sure...
September 4, 2014 at 12:46 am
Eirikur Eiriksson (9/3/2014)
BTW, the bouncing is easy, it's the catching of the server exceptions which is tricky
You just need a large net. What's so difficult about that?
September 3, 2014 at 3:01 pm
CheckTable isn't all that checkDB does. Try CheckAlloc and CheckCatalog.
Have you tried the restart that the message mentions?
September 3, 2014 at 12:11 pm
I don't even know if it'll work though. Also may cause problems when you go to deploy scripts. SQL treats 'table doesn't exist' and 'permission denied' the same way. You...
September 3, 2014 at 8:15 am
Viewing 15 posts - 7,921 through 7,935 (of 49,571 total)