Viewing 15 posts - 5,401 through 5,415 (of 9,244 total)
muthyala_51 (6/29/2012)
I am new to clustering.Do we need to create linked server on both the nodes ? and how about the jobs?
No, they are created at the instance level, when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2012 at 7:14 am
This all depends entirely on how you will present the storage to the servers. Is this a new cluster or adding a virtual to an existing cluster.
Which virtualisation platform are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2012 at 3:55 am
Codezilla-292868 (6/28/2012)
We have one instance instance 1 running on node A. And I have an instance 2 running on node B.
If you only have 2 nodes in the cluster this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2012 at 3:52 am
You do not need to manually manage the log shipping backup files, they are managed by the log shipping system stored procedures and the agent jobs.
Personally i would recommend that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2012 at 6:22 am
Yes 2008 you have to edit the tcpip bindings in the registry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 2:25 pm
Steve Jones - SSC Editor (6/27/2012)
Enjoy. Save some $$ for tickets 😉
Surely you mean £££ 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 12:52 pm
Source and destination db, etc are a collection of items under the database details property
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 11:20 am
Vertigo44 (6/27/2012)
should I place DTC on one of the SQL Group Volumes?
If you do this you'll need to put the DTC resources in the same cluster group as the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:52 am
SQLRNNR (6/27/2012)
The image won't come up for me.
it should open in a new window, alternatively the car is pictured here 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:48 am
*yawn*
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:13 am
hi thanks for your comments, hope you found it useful
Regards Pez
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 8:21 am
to be clear this details the types
catalog views
compatibility views
dynamic management views (which also includes functions)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 8:19 am
what does the following registry branch show
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 4:55 am
for info, sys.master_files is a catalog view not a DMV
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 4:01 am
the declaration you have made for@Data1 is only relevant to the internal part of the procedure. You are attempting to pass a parameter @Data1 from outside the procedure and would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 3:43 am
Viewing 15 posts - 5,401 through 5,415 (of 9,244 total)