Viewing 15 posts - 8,296 through 8,310 (of 9,244 total)
Achtang (4/2/2009)
Perry Whittle (4/2/2009)
surely you would restore a backup of the master database from that server that wasn't corrupt
Woww..you are here again :).
so lets say I have a Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 7:23 am
prvreddy (4/2/2009)
Hi All,Which service pack of Sql server 2005 will support upgradation from sql server 2000 to 2005?
Thanks in advance
Vijay
upgrading is not affected by service pack, they are installed after...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 7:19 am
Achtang (4/2/2009)
Did you mean the security configuration I meant the required port?and also
Did you mean to design our maintenance plans and backup plans?
for sql2005 post installation you should ideally...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 7:12 am
your welcome, give the virtual server idea a crack it'll make an ideal testbed for you and you wont get fired for wrecking it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:59 am
surely you would restore a backup of the master database from that server that wasn't corrupt
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:57 am
Achtang (4/2/2009)
Ia m new to SQL server, its been 6 months or so. Trying to get some knowledge. Hope you guys understand and help me out to the questions I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:49 am
LAW1143 (4/2/2009)
unfortunately I dont have a cluster that isnt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:45 am
when you install the database engine on a sql cluster the wizard looks normal for the first few steps and will ask you to specify the instance name. There will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:43 am
either way there can only ever be 1 default instance of sql when installing multiple instances. With clustering remember the virtual name and IP are used to connect to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:36 am
iqtedar (3/30/2009)
i was just wondering if someone has the files for dev edition can i just copy and install.
that would possibly fall under the realm of software piracy 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2009 at 2:57 pm
like the man says, the cluster virtual name and ip address must be unique on the network
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2009 at 2:55 pm
great article. For free source control try Subversion, you can get it at
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2009 at 2:46 pm
sbk (3/23/2009)
[p] databases are in full recovery model [/p]
log is purged at transaction log backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2009 at 7:02 am
EdVassie (3/23/2009)
...and they may have run the install from the Tools CD or folder instead of the Server CD or folder. 🙂
Ed, my guess is we wont find out...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2009 at 6:35 am
Florian Reischl (3/22/2009)
Thanks for your corrections in this thread and others. I'm not from England/America and sometimes I'm tryin' to read faster than my...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 8:10 am
Viewing 15 posts - 8,296 through 8,310 (of 9,244 total)