Viewing 15 posts - 6,301 through 6,315 (of 9,253 total)
never tried it myself, i have always cleaned up the clustered applications and then evicted the node. After evicting the node if you attempt to add it back it will...
October 31, 2011 at 9:35 am
GRussell31 (10/31/2011)
We are planning on upgrading a SQL 2000 database to SQL 2008 R2 shortly with the new database being house on a windows clustered machines with a central filestore...
October 31, 2011 at 6:57 am
Yuri55 (10/31/2011)
(sorry, cannot provide details- it's in PCI zone).
wait a minute, so you cant tell me the default logical names of TempDev and TempLog and the default physical filenames of
?:\blah\blah\tempdb.mdf
?:\blah\blah\templog.ldf
with...
October 31, 2011 at 6:41 am
extract any reports, etc from the 2005 instance using Reporting services scripter tool(unless you have backups, which you do have dont you 😉 )
uninstall the sql server 2005 instance, you...
October 31, 2011 at 5:17 am
Yuri55 (10/29/2011)
return different file numbers- 4 vs 3? Funny enough but I can see all...
October 31, 2011 at 5:10 am
prashant-507002 (10/31/2011)
What is log shipping and how to use it?Is this option available in SQL server 2005 express addition with advance version?
This link details log shipping.
Log shipping is not available...
October 31, 2011 at 5:06 am
Elliott Whitlow (10/27/2011)
I would mount the new drives in as different drive letters.
I would add the new drives to the resource group.
Then I...
October 31, 2011 at 5:00 am
larrykl (10/29/2011)
Trying to install a 2 node Active/Passive SQL Server cluster but it is failing due to the fact that it can't find an available shared disk. I...
October 31, 2011 at 4:48 am
Windows 2008 no longer uses a dedicated account for the cluster service, this is system managed.
Please read my response to your other post regarding taking a little more time to...
October 31, 2011 at 4:46 am
larrykl (10/31/2011)
I didn't realize shared storage is a requirement. We already popped for Win2K8 Ent. Edition too.
exactly why you should always research what is required before purchasing anything, even...
October 31, 2011 at 4:35 am
Thank you Mohammed
October 30, 2011 at 11:31 am
ALZDBA (10/28/2011)
clustering. Is another HA. Option which has its own downsides.
and overkill if you only have a handful of databases
October 28, 2011 at 7:02 am
spidey73 (10/27/2011)
The database files are on the SQL server itself.
The SQL service account is a Active Directory account that got access to the database file...
October 28, 2011 at 6:33 am
run NET SHARE on the passive node and check the output
October 27, 2011 at 2:14 am
can you post details of the query, table and the indexes
October 27, 2011 at 2:04 am
Viewing 15 posts - 6,301 through 6,315 (of 9,253 total)