Viewing 15 posts - 1,666 through 1,680 (of 9,244 total)
terry999 (10/8/2015)
I have no idea how it is configured as Virtual server e.g. on the physical machine.
From user of the virtual machine it appears at 2 disks,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2015 at 7:39 am
all replies to this thread please
http://www.sqlservercentral.com/Forums/Topic1726452-3411-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2015 at 7:38 am
Benki Chendu (10/9/2015)
I am unable to add the server in other subnet to the windows failover cluster. Need help around that area..
Then you'll need to refer to my Stairway to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2015 at 7:36 am
EasyBoy (10/8/2015)
i.e New ServerName is A (2014) and old ServerName is B (2005). Then we want to rename A (2014) to B.
Never mind. We...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2015 at 7:33 am
are you saying with a restore you wont see enough recovery to cause any impact?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2015 at 7:31 am
jackimo (10/8/2015)
We run SQL Server on VMWare with an EMC San. ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 10:30 am
you'll need to drop the constraint and recreate it, if you don't specify any different the clustered index will be create on the PK columns.
Drop the constraint using
ALTER TABLE [schema]....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 10:26 am
terry999 (10/8/2015)
We have a SQL Server running on a virtual platform.
I was wondering if the old recommendations w.r.t disks still make a difference, things like
1. Logs on one disk data...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 10:17 am
so, you have 2 separate computers one with old version of windows and sql 2005, the other windows 2012 with sql server 2014, correct?
You want the sql server instance on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 10:14 am
thank you for your feedback, I'm hoping that users find the index column order data useful too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 9:13 am
masking is not available in the sense that Oracle provides, as said already, just provide update scripts to obfuscate the tables
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 4:26 am
Duran (10/7/2015)
I hope somebody can point me in the right direction. I am trying to do the above using the following...
ALTER SCHEMA [dbo] TRANSFER [schemaame].[tablename];
...but getting the following error...
Msg...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 4:14 am
SQL Galaxy (10/8/2015)
Hello Mr. Perry..What I am asking,
1. I should enter the unique IP address in access point administration portion while creating cluster group.
Yes when creating the windows server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 3:51 am
Chitown (10/7/2015)
I created 2 DBs with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 3:44 am
ports for what
SQL Server
DNS
NetBIOS?????
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 3:39 am
Viewing 15 posts - 1,666 through 1,680 (of 9,244 total)