Viewing 15 posts - 6,286 through 6,300 (of 9,241 total)
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
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 4:46 am
Viewing 15 posts - 6,286 through 6,300 (of 9,241 total)