Viewing 15 posts - 931 through 945 (of 3,738 total)
Keith Tate (1/21/2014)
LOG_BACKUP
I do not understand what is going on.
This means that it is waiting on a transaction log backup
So what do I need to do to rectify the situation?
January 21, 2014 at 9:46 am
Keith Tate (1/21/2014)
I have a job to backup the Transaction Log of a Database.
Have you checked that the job is completing successfully? How often are you running the job and...
January 21, 2014 at 9:33 am
Keith Tate (1/21/2014)
January 21, 2014 at 9:29 am
Keith Tate (1/21/2014)
So, what is the reason to shrink the log file?
It grew to over 100 GB.
It keeps growing.
I created this Database (Data Warehouse) years ago.
It was never a problem...
January 21, 2014 at 9:23 am
Keith Tate (1/21/2014)
January 21, 2014 at 9:19 am
I never set that option.
I'm not sure how that happened.
It is a mastery but all off my backup maintenance plans/jobs for that Database got deleted.
Thank you very much!:-)
January 21, 2014 at 8:58 am
Thanks. Your responses are very much appreciated. I'm amazed at you knowledge and expertise.
I have another weird one related to the transaction log.:w00t:
http://www.sqlservercentral.com/Forums/Topic1533161-1550-1.aspx
Thanks!
January 21, 2014 at 8:56 am
It is ok. The size of the file went from over 10 Gb to 49 GB.
Thanks.
January 21, 2014 at 3:00 am
GilaMonster (1/21/2014)
GilaMonster (1/19/2014)
Finally a rare reason is someone, after the restore, runs BACKUP LOG ... WITH NORECOVERY, either manually or in a job.
When you check the...
January 21, 2014 at 1:46 am
A backup was performed by Microsoft thru the GUI and unchecked the Backup the Tail of the Log and leave the Database in a restoring state.
I was tired. I do...
January 21, 2014 at 1:30 am
U have to be kidding.
January 18, 2014 at 4:57 pm
The RESTORE Database WITH RECOVERY by itself did not work.
I had to drop the database and restore WITH RECOVERY.
January 18, 2014 at 8:54 am
Lynn Pettis (1/18/2014)
Welsh Corgi (1/18/2014)
I had to drop the database and restore. Basic syntax.
I think the problem was that they did not stop the SQL Server Services before they started...
January 18, 2014 at 8:52 am
Lynn,
I had to drop the database and restore. Basic syntax.
I think the problem was that they did not stop the SQL Server Services before they started the Windows upgrade.
I would...
January 18, 2014 at 7:12 am
I restored the database and it was operational.
Then it went back into a restoring state.
So I dropped it and started a restore.
January 17, 2014 at 4:27 pm
Viewing 15 posts - 931 through 945 (of 3,738 total)