Viewing 15 posts - 5,731 through 5,745 (of 9,241 total)
jgflufg (4/10/2012)
All sql disks are mount points(system,temp,data,log).The mount point disk for system dbs for all sql instances is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 2:38 am
sqlfriends (4/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 11:39 pm
Lynn Pettis (4/10/2012)
Perry Whittle (4/10/2012)
jitendra.padhiyar (4/10/2012)
Yes Pettis,I selected the option " Restore With Norecovery" during restore of db. But still the same status.
you also need to take and restore at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 5:01 pm
you'll need to work with your domainetwork admins to ensure everything is set up correctly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 4:59 pm
If you have a SQL server MYSERVER with named instance INST1 you may only change the server name. The instance name will remain as it was installed like so
MYSERVER\INST1 to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 4:45 pm
Divine Flame (4/10/2012)
Perry Whittle (4/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 4:30 pm
So, if you have a public network connection with IP 192.168.1.30 and a secondary backup network with IP 10.10.10.30 and you copy backups to the backup server whose IP is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 4:17 pm
jitendra.padhiyar (4/10/2012)
Yes Pettis,I selected the option " Restore With Norecovery" during restore of db. But still the same status.
you also need to take and restore at least 1 transaction log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 4:14 pm
Mohammed Imran Ali (4/10/2012)
But some of the files are in different location.
That's a problem, see my article at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 4:08 pm
nocode99 (4/10/2012)
Thanks - in an A/A cluster, each instance would need its own Root Disk, correct?
Since the root disk becomes a dependency in the installed clustered instance group, create a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:44 pm
sqlfriends (4/9/2012)
So, what exactly the step you do for keeping the same name?
rename windows server, then use sp_dropserver followed by sp_addserver.
Note you cannot rename the instance name only the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:38 pm
are the drive\file paths identical on both servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:28 pm
what IP ranges do you have assigned to the NICs, what IP are you copying backups out to?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:24 pm
thelegendarywolf (4/9/2012)
Hi All,As per application upgradation/design, we're suppose to change the physical IP of the nodes for an Active/Passive cluster.
Why?
thelegendarywolf (4/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:22 pm
make the root disk as small as possible, i usually use a size of around 100MB. See my article at this link[/url] for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:09 pm
Viewing 15 posts - 5,731 through 5,745 (of 9,241 total)