Viewing 15 posts - 2,896 through 2,910 (of 6,677 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...
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...
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...
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...
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,...
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...
January 26, 2012 at 11:53 am
Does this table contain any (n)varchar(max) columns or xml columns?
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...
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...
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...
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...
January 4, 2012 at 3:00 pm
Perry Whittle (1/4/2012)
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...
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...
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.
December 19, 2011 at 12:24 pm
Viewing 15 posts - 2,896 through 2,910 (of 6,677 total)