Viewing 15 posts - 6,286 through 6,300 (of 9,244 total)
the .NET framework is required for SSMS to be available!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2011 at 6:10 am
no, clusters are essentially mutli master
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2011 at 6:07 am
Seems good to me, although
derekr 43208 (11/1/2011)
6. Add the Node to the possible owners list for all Services and Apps
The sql server installation routine takes care of this for you,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2011 at 3:46 am
you can't, the transaction log is used to recover the database during a restart!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 10:52 am
jeanpaulva (10/31/2011)
I wanted to turn off the logging of database.How can i achieve that?
.log?
is this an IIS issue?
You dont turn off logging to the SQL Server database. It sounds to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 10:20 am
/X:destination
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 10:19 am
rcaers (10/31/2011)
I get the same error. Don't know what went wrong (it worked just fine), but when I now open SSMS I get the same error. Do you have a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 10:14 am
take your point but dont agree.
we'll agree to disagree on this one 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 10:00 am
EdA ROC (10/31/2011)
We do have RAID servers as a further safe guard.
safeguard against what?
Presumably you mean you have RAID drive configurations not servers?
RAID is used for redundancy and performance,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 9:52 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 5:06 am
Viewing 15 posts - 6,286 through 6,300 (of 9,244 total)