Viewing 15 posts - 226 through 240 (of 4,272 total)
Can you use SQLCLR?
If so then you can use something like to check for the file: https://nclsqlclrfile.codeplex.com/%5B/url%5D
CEWII
June 17, 2013 at 2:42 pm
I know you said everything is spelled correctly and you could connect via telnet and ping.
I'm verifying that you are trying telnet and ping by name and not IP address,...
June 17, 2013 at 1:58 pm
Just the servers are the question?
I think you will have some issues with the SAN setups.
I'm thinking you might want to evict one of the nodes and build the new...
June 17, 2013 at 1:50 pm
SQL Clusters require a unique virtual name for each instance so you cannot do:
SQLName\Instance1
SQLName\Instance2
SQLName\Instance3
You must do:
SQLName1\Instance1
SQLName2\Instance2
SQLName3\Instance3
I believe this is because the virtual name/IP can only be active on a single...
June 5, 2013 at 1:34 pm
You could setup a script to watch the file for a period of time and see of the file size changes over that time, if it doesn't it could be...
April 11, 2013 at 12:33 pm
I think the missing binary code is your clue. It often (usually?) means that there was a build error in your script. Open the script and check the...
February 27, 2013 at 12:59 pm
How is that project compiled? Is it set for 64/32 or both, if its not explicitly set I think it will use 64 on a 64 bit OS and...
December 11, 2012 at 8:58 am
If they are looking for a junior developer you *may* be ok, but I am hard pressed to believe you are ready to become a DBA which is one the...
December 8, 2012 at 1:46 pm
Yes
CEWII
December 8, 2012 at 11:43 am
You have to rename the old name or when you try and change the new server to the old name it will complain about a duplicate, it won't just take...
December 7, 2012 at 3:23 pm
APA0876 (12/7/2012)
when you say create the SQL server cluster with same virtual name than the 2005. Can this be done while they both are on the same domain?
Please re-read, "Build...
December 7, 2012 at 2:11 pm
I can think of a couple potential issues.
Where did you change it? The name could be fed from a variable that is then used as an expression. Also...
December 7, 2012 at 12:05 pm
Ok, sorry I had gotten busy on other things.
Basically you have an side by side upgrade and you want the server names and instance names to be the same in...
December 7, 2012 at 8:40 am
Maintenance and backups are a challenge.
Table partitioning can be a consideration.
CEWII
December 5, 2012 at 1:32 pm
The instance or the virtualname?
For the instance I know of know supported way other than re-install. Virtualname is actually pretty easy.
Which is it?
Also you posted this in the wrong...
December 5, 2012 at 1:06 pm
Viewing 15 posts - 226 through 240 (of 4,272 total)