Viewing 15 posts - 2,896 through 2,910 (of 6,676 total)
The Cleanup History Task removes history for several areas. It will only work for the job history if you disable the default setting on the History page for SQL...
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
February 14, 2012 at 12:22 pm
A database file will only grow when all the space in the file has been used - and the autogrowth setting is defined. That setting should be defined 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
February 14, 2012 at 12:15 pm
I would go with backup/restore for the user databases and not worry about the system databases. Build the systems at the new site, script out all jobs and logins...
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
January 31, 2012 at 12:51 pm
plaid_draco (1/31/2012)
Thank you for the quick responses! Very helpful.I guess my assumption that an active-active cluster would avoid that problem is unfounded. 😀
Well, there are a couple...
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
January 31, 2012 at 12:42 pm
The version you are on had issues with maintenance plans and there were also issues with xp_delete_file.
You really need to upgrade to SP3 - and if that is not possible,...
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
January 26, 2012 at 11:57 am
Another thing you need to realize is that when you rebuild/reorganize an index - SQL Server will spread the data across both files according to the proportional fill algorithm.
After 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
January 26, 2012 at 11:53 am
Does this table contain any (n)varchar(max) columns or xml columns?
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
January 18, 2012 at 3:59 pm
It really depends on where you are backing up to - and whether or not everything is on the same fabric, SAN, disks, etc...
It also depends on how much cache...
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
January 15, 2012 at 7:57 am
BTW - inserting data using an ORDER BY clause will not guarantee that the data is inserted with no fragmentation. Even if you have an IDENTITY column as 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
January 5, 2012 at 1:43 pm
Define what you mean by one disk - is that a single LUN presented from a SAN? If so, how is that LUN setup on the SAN?
What you can...
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
January 4, 2012 at 3:18 pm
You cannot use UNC paths with SQL Server.
I would recommend downloading the trial version of Redgate's SQL Virtual Restore. After reviewing the functionality, you can then determine whether or...
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
January 4, 2012 at 3:00 pm
Perry Whittle (1/4/2012)
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
January 4, 2012 at 2:53 pm
Having just installed the latest version on several clusters - I can say that you have the option. I chose to run the installation on each node since trying...
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
December 23, 2011 at 7:59 am
raotor (12/21/2011)
4. So, the "append to existing media set" option will actually overwrite an earlier backup set if that one has expired?
No - these options are really only valid when...
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
December 21, 2011 at 1:11 pm
Verify that the login and user in msdb match exactly as the AD account. This is case-sensitive and must match in order for it to work.
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
December 19, 2011 at 12:24 pm
Viewing 15 posts - 2,896 through 2,910 (of 6,676 total)