Viewing 15 posts - 3,961 through 3,975 (of 9,244 total)
What have you done to address the issue below??
New persopn (9/2/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2013 at 3:08 am
SQL Surfer '66 (9/2/2013)
Perry Whittle (8/30/2013)
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.
In case it gets necessary: You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2013 at 5:35 am
OLDCHAPPY (8/30/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2013 at 9:03 am
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2013 at 8:57 am
Andreas Wolter-332291 (8/29/2013)
You have no idea what's possible
Really, you think? :hehe:
Andreas Wolter-332291 (8/29/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2013 at 6:41 am
I have never hacked SQL server to attempt this not sure i'd even want to. Not even sure this would actually be possible due to the registry hive structure.
When following...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2013 at 2:06 am
For clarification
I have a 3 node cluster comprising Node1, Node2 and Node3.
I create a clustered default instance on Node2 and Node3. I then attempt to install an instance (clustered...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2013 at 11:24 am
HanShi (8/28/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2013 at 3:40 am
dokledon (8/28/2013)
For StandAlone, no doubt.
For stand alone or cluster, no doubt!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2013 at 3:15 am
dokledon (8/27/2013)
Andreas Wolter-332291 (8/27/2013)
Andreas,
1) About having unique or multiple default instances inside a cluster, my doubt persist (see HanShi answer. It's a good debate)
2) About Alias, I thought about it....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2013 at 11:46 pm
HanShi (8/27/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2013 at 5:18 pm
Placing system dbs on C is not too dramatic as the boot drive it will always be online while the server is up. Obviously tempdb and distribution db should be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2013 at 11:21 am
Dont panic, what was the exact command you used?
Get the current paths from sys.master_files and compare them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2013 at 11:16 am
dokledon (8/25/2013)
Can I have:
- Node 1: SQL1\Default and SQL2\Default (different/unique SQL VIP Name w/ Default Instance)
- Node 2: SQL3\Default and SQL3\Default
,so It won't be necessary to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2013 at 4:03 am
yes the loss of that drive\folder will stop sql server from running, the system database path is where the master database sits and is critical for sql server operation.
You can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2013 at 3:56 am
Viewing 15 posts - 3,961 through 3,975 (of 9,244 total)