Viewing 15 posts - 4,936 through 4,950 (of 6,676 total)
Chris (6/26/2009)
Ever get the following error when running it?
"
Procedure dba_indexDefrag_sp dropped
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table...
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 26, 2009 at 9:35 am
anders (6/25/2009)
We do bckup our file based backups like transactions log backup to a secondary backup system every day.
That is good - but have you verified when that job starts...
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 25, 2009 at 6:54 pm
I would make sure that Backup Exec is not running a step to truncate the log or switch the recovery model. If it is doing either of those -...
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 25, 2009 at 6:46 pm
Verify the SMTP server configuration and that you can get to that server from the cluster. What version of SQL Server 2005 are you on? I think there...
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 25, 2009 at 6:40 pm
Well, I still don't understand what problems you are having. I have multiple cluster systems on SP2 and SP3 as well as SQL Server 2008 RTM and SP1.
We 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 25, 2009 at 11:11 am
Did you try viewing the history for the maintenance plan? Right-click on the maintenance plan and View History.
This should show you which step failed and why.
When you say incremental,...
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 25, 2009 at 11:03 am
The answer to your question is: It depends. I know, good answer - right 😀
On some systems, I have used a single plan to backup all user databases because...
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 25, 2009 at 10:35 am
arctica82 (6/25/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 25, 2009 at 10:16 am
nscott (6/24/2009)I have 400 GB of free disk space on the SQL server. For log properties, initial size = 195 MB; autogrowth = By 10 MB, restricted growth to...
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 25, 2009 at 10:09 am
Here is one of the better scripts available for this:
http://sqlfool.com/2009/03/automated-index-defrag-script/
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 24, 2009 at 5:22 pm
Double check the ANSI_PADDING settings on both servers? My guess is they are not the same...;-)
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 24, 2009 at 3:45 pm
First, you don't need to stop the services prior to upgrading. It works much better if you leave the services started, that way the install can actually connect to...
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 24, 2009 at 3:42 pm
Run the following query:
SELECT Name, recovery_model_desc, log_reuse_wait_desc
FROM sys.databases
Find your database and see what SQL Server is reporting for why the log cannot be reused. This will also...
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 24, 2009 at 3:24 pm
arctica82 (6/24/2009)
Sorry, I am a little bit confused.So,can I install SQL SERVER 2008(Database Engine+Client tools) on local drive of one of nodes without creating any problem for Clustered environment.
Yes -...
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 24, 2009 at 3:05 pm
Verify when the snapshot is occurring and double-check to make sure there are no other processes running at the same time.
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 24, 2009 at 2:56 pm
Viewing 15 posts - 4,936 through 4,950 (of 6,676 total)