Viewing 15 posts - 9,841 through 9,855 (of 49,571 total)
Take a read through this, identify why it's growing. Post back if you need further help once you've identified the root cause
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
March 3, 2014 at 8:48 am
dan-572483 (2/28/2014)
If a rebuild of a clustered index was stopped before completion, I would think that might be a problem.
No. The rebuild will roll back completely leaving the index...
March 3, 2014 at 8:47 am
I see this is going to require some careful planning...
March 3, 2014 at 8:38 am
j-1064772 (3/3/2014)
So - short or creating - after the fact - a trigger to update the usage date upon each call
Yup, that's how you do it. Not a trigger,...
March 3, 2014 at 7:52 am
Check the SQL Server error log for details on why the backup failed (the error log doesn't show that job failed message). Check the details of the job failures (ie...
March 3, 2014 at 7:51 am
Step 1: Check the SQL error log and job history and see why it failed.
March 3, 2014 at 7:13 am
Definitely not good.
GilaMonster (3/3/2014)
What's the exact state of the database (from sys.databases)?
March 3, 2014 at 6:15 am
ChrisM@Work (3/3/2014)
GilaMonster (3/3/2014)
ChrisM@Work (3/3/2014)
GilaMonster (3/3/2014)
March 3, 2014 at 6:14 am
That's not an error message, that's informational.
Please can you answer my questions. I really need to see all and every message relating to that database in the SQL error log....
March 3, 2014 at 5:58 am
Why not?
What's the exact state of the database (from sys.databases)?
What are the errors in the error log relating to this DB (from just after the restart)?
How critical is this database?
March 3, 2014 at 5:40 am
ChrisM@Work (3/3/2014)
GilaMonster (3/3/2014)
March 3, 2014 at 5:33 am
Restore from backup, that's the best approach by far, may be the only one.
March 3, 2014 at 5:25 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Under the section on model. You'll need a backup of model, a copy of model from another identical server or to rebuild the system DBs.
March 3, 2014 at 5:19 am
rodjkidd (3/3/2014)
GilaMonster (3/3/2014)
BrainDonor (3/3/2014)
SQL Bits XII has finally been announced http://www.sqlbits.com/.Wooot!
Next problem, what do I submit?
Almost posted last night that site was up. But apparently we shouldn't have noticed until...
March 3, 2014 at 5:16 am
Viewing 15 posts - 9,841 through 9,855 (of 49,571 total)