Viewing 15 posts - 4,966 through 4,980 (of 6,676 total)
Robb (6/22/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 2:27 pm
Glad I could help - I am happy to hear that you already have the tools, now it's just a matter of setting it up.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 2:02 pm
Robb (6/22/2009)
Jeff-Same file for Transaction Log backup.
Init on the first run and append there after.
Robb
And there is your problem. Find out what time that file is getting backed up...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 1:50 pm
Are you backing up to a differently named file each time? Or, are you backing up to the same file all the time?
If the same file, then you are...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 1:33 pm
I would spend the money on Redgates SQL Compare tools. You would need the professional version to be able to automate the process daily.
What you would schedule would be...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 1:30 pm
In a cluster, the SQL Server service is not running on the non-active node. When the failover occurs, Cluster Administrator starts SQL Server on the non-active node making it...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 11:48 am
Using Powershell, the first step is to load the SMO libraries:
PS> [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.SMO") | Out-Null
The next step is to setup the list of the SQL Server instances we want to access,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2009 at 9:05 pm
Jeff Moden (6/21/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2009 at 11:39 am
GilaMonster (6/20/2009)
Jeffrey Williams (6/20/2009)
The maintenance plan plug-in uses UPDATE STATISTICS.
So if you're using the default maint plans, updating stats after rebuilding indexes will (I think) lead to a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2009 at 11:31 am
The automated way of handling this is to perform regular transaction log backups. Every hour would be a good start, but you then need to follow up with the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2009 at 3:17 pm
The maintenance plan plug-in uses UPDATE STATISTICS. I get around this by using an Execute SQL Task and executing:
Use db1; Execute sp_updatestats @resample = 'RESAMPLE';
Use db2; Execute sp_updatestats @resample...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2009 at 3:15 pm
GilaMonster (6/20/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 20, 2009 at 2:57 pm
I would use Powershell and SMO - in fact, that is exactly what I use. I run a script every morning that hits all 160 SQL Servers and returns...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 19, 2009 at 7:51 pm
Steve Jones - Editor (6/19/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 19, 2009 at 1:53 pm
With your setup - I would never set up mirroring in synchronous mode. With a geographically separated system you would need a dedicated network to make sure you could...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 19, 2009 at 9:55 am
Viewing 15 posts - 4,966 through 4,980 (of 6,676 total)