Viewing 15 posts - 3,961 through 3,975 (of 9,241 total)
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
for more info on mountpoints see here[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2013 at 5:20 am
these may help
alwayson with clustered instances[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2013 at 5:10 am
BobMcC (8/20/2013)
Rather than have one file group with files on six LUNS; perhaps have multiple file groups;...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2013 at 10:59 pm
Viewing 15 posts - 3,961 through 3,975 (of 9,241 total)