Viewing 15 posts - 9,841 through 9,855 (of 49,552 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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2014 at 8:47 am
I see this is going to require some careful planning...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2014 at 7:51 am
Step 1: Check the SQL error log and job history and see why it failed.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2014 at 7:13 am
http://www.sqlservercentral.com/articles/Administration/64582/
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2014 at 7:12 am
Definitely not good.
GilaMonster (3/3/2014)
What's the exact state of the database (from sys.databases)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2014 at 5:40 am
ChrisM@Work (3/3/2014)
GilaMonster (3/3/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2014 at 5:33 am
Restore from backup, that's the best approach by far, may be the only one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2014 at 5:16 am
Viewing 15 posts - 9,841 through 9,855 (of 49,552 total)