Viewing 15 posts - 61 through 75 (of 305 total)
Yes, they are single mdf and ldf databases! Also split up on seperate volumes as well, my log files are all together while my mdf's are on multiple volumes.
I am...
July 22, 2010 at 11:19 am
Just looked at our Sharepoint databases and I only see this happening on Search databases when doing a "Crawl". I am still new when it comes to the behavior of...
July 21, 2010 at 1:06 pm
NOTE: if you have hyperthreading enabled it gets MUCH worse. Consider disabling HT if you are seeing logs of CXPACKET waits first, then reevaluating and if necessary adjust MAXDOP.
where to...
July 20, 2010 at 4:12 pm
Thank you,
I would go for increasing drive space on Dev server as there is no other option:-):-)
July 20, 2010 at 11:45 am
can you post the results of below queries
select @@version
select serverproperty('edition')
select serverproperty('productlevel')
thanks
July 17, 2010 at 10:40 pm
2. Run DBCC UPDATEUSAGE
3. Run DBCC CHECKDB(DBNAME) WITH DATA_PURITY
when you upgraded from SQL Server 2005 to 2008, are the above two steps required? if Yes then why we need to...
July 16, 2010 at 5:18 pm
It is not possible to prevent some components going to the C drive, some will no matter what you do
It would be appreciated if you provide the components that install...
July 7, 2010 at 10:43 pm
In add\remove programs select "Change"
Once the installer starts it will prompt you to select the instance to change, select the clustered instance and click next.
The next screen asks you again...
July 7, 2010 at 2:24 pm
ok and what did you select after this when the installer runs?
From Add/remove programs, I have selected remove and in the SQL Server setup wizard, I have selected the cluster...
July 6, 2010 at 10:30 am
what steps are you performing to remove the clustered instance?
Having resources on node1, I tried to uninstall SQL Server 2005 clustered instance from Add/Remove programs
July 5, 2010 at 10:26 am
From the link http://msdn.microsoft.com/en-us/library/ms190438.aspx
Side-by-side installations of SQL Server 2008, SQL Server 2000, and/or SQL Server 7.0, where any of the versions is uninstalled.
Side-by-side installations...
July 3, 2010 at 10:57 am
On one node we have database engine & SSIS and on another node just the database engine and NO SSIS.
But the in-place upgrade is successful. Here my results contradicting the...
June 30, 2010 at 7:28 pm
I got the answer:
select name,version from sys.sysdatabases
Version for SQL Server 2008 is 655
Version for SQL Server 2008 R2 is 661
thanks
June 30, 2010 at 10:47 am
Mani,
I am planning to do a in place upgrade from SQL Server 2005 to SQL Server 2008 in a active/passive cluster environment. Its one our critical server. How did your...
June 30, 2010 at 10:41 am
Viewing 15 posts - 61 through 75 (of 305 total)