Viewing 15 posts - 166 through 180 (of 318 total)
I can't help but wonder, are you sure it is the actual database and not the log file they are shrinking each week? Not that this makes it that...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 4, 2011 at 1:20 pm
1)is the patch needed? - Depending on what features of SQL Server 2005 you are currently using. Please review the following for the list of "bugs fixed" by Microsoft...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 4, 2011 at 1:15 pm
Is your OS Small Business Server? If so, I believe there was a registry key modification that was needed to perform the installation.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 4, 2011 at 12:52 pm
Sorry I am a little late to the party but Elliott is correct. Using the Wizard is the most efficient and less stressful way to upgrade a 6.5 database....
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 4, 2011 at 12:44 pm
Have you checked out the following KB article?
http://support.microsoft.com/kb/923355
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 27, 2011 at 1:17 pm
Have you had a chance to read Dinesh Asanka's article on the backup of an SSAS database?
http://www.sqlservercentral.com/articles/Analysis+Services+(SSAS)/63382/
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 27, 2011 at 1:11 pm
What is the unused space within the db
select [FileSizeMB] = convert(numeric(10,2)
, round(a.size/128.,2))
, [UsedSpaceMB]...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 25, 2011 at 2:42 pm
Have you verified what the error message is telling you? - When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 24, 2011 at 10:48 am
Can you please post the message in the SQL Server Agent | Jobs | Job_name | History | Log File Viewer?
This should give you a lot more information other than...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 24, 2011 at 10:32 am
7,990 characters
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 24, 2011 at 10:29 am
We perform a Full Backup weekly and a Differential Backup nightly on our Development AND QA SQL Servers. Partially as a way to mimic the Production environment, partially to...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 19, 2011 at 10:46 am
Sushant - did you take a look at Michelle Ufford's Index Rebuild Script I sent you a link? In it she explains how you can set a time limit...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 19, 2011 at 6:53 am
There may not be any available room in the database to shrink it. Please run the following script, it will tell you the amount of used/unused space in the...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 17, 2011 at 1:29 pm
You may need to rebuild/reord the indexes a table at a time. It is virtually impossible to guess how much log space is required for an entire rebuild without...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 17, 2011 at 1:14 pm
Do you know how much space is used/unused in the database? This may be useful information to pass on to the CIO. If there is only 20% or less...
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 12, 2011 at 12:57 pm
Viewing 15 posts - 166 through 180 (of 318 total)