Viewing 10 posts - 1 through 10 (of 10 total)
Yesterday, I found a suspect DB. The drive had disappeared after a server cycle and
the log file was missing. I performed a restore from the last backup and pointed the...
December 17, 2003 at 3:21 pm
At first blush, Chris has put together
a well thought solution for an option
of creating SQL log shipping.
Excellent work Chris!
November 26, 2003 at 8:48 am
For the db that has a failed TLog backup,
has the full backup run with success?
You must have a full backup completed before
the TLog backup can run with success.
Also, to be...
October 23, 2003 at 7:12 am
On one instance of SQL Server tempdb,
a few days ago was 400 MB.
Today, that guy grew to 20 GB.
October 20, 2003 at 2:59 pm
You should use sp_force_shrink_log, written by Andre Zanevsky. It works on 7.0 and 2000.
October 16, 2003 at 1:15 pm
I would have you monitor the disk I/O to
look for a bottleneck. You may not have
enough fiber connections on the SAN.
What drives are on the SAN?
For this example,(tran logs and...
October 16, 2003 at 8:00 am
When I can, I put log files on a disk by itself; to minimize failure.
October 6, 2003 at 2:18 pm
My solution includes a maintenance plan
for log shipping for the hours 8 AM to 6 PM.
Then I have a full backup job that runs
at 7 PM. So, I have a...
June 24, 2003 at 8:52 am
How many DBs are log shipped?
SQL Agent failed on the primay server,
the failover server, or the monitor?
When did SQL Agent fail?
And what does the Windows event log say
before it stops...
June 23, 2003 at 8:38 am
Viewing 10 posts - 1 through 10 (of 10 total)