Viewing 15 posts - 166 through 180 (of 317 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...
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...
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.
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....
February 4, 2011 at 12:44 pm
Have you checked out the following KB article?
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/
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]...
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...
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...
January 24, 2011 at 10:32 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...
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...
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...
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...
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...
January 12, 2011 at 12:57 pm
Viewing 15 posts - 166 through 180 (of 317 total)