Viewing 15 posts - 211 through 225 (of 469 total)
Yes I think I planned to do it the way you mentioned above with the backup and restore.
I will work on installing Litespeed on the new server so that...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 11:24 am
If I understand it correctly you will be running 5 instances on this Active/Passive cluster.
In any case you would make the shared drives to be owned by the node that...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 11:19 am
Gift Peddie (2/4/2009)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 11:14 am
Daveee (2/4/2009)
This might prove to be lower risk and slightly less downtime. You...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 11:08 am
yulichka (2/4/2009)
Do I change @dbname to my database name. I know I have change id?
In the code it has to be @dbname, then create the SP. When executing it mention...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 10:52 am
Gift Peddie (2/4/2009)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 10:48 am
Daveee (2/4/2009)
I'm quite certain there is no direct upgrade path from x86 to x64in SQL 2005.If backup and restore isn't an option, detach/attach should be a fair bit quicker.
I guess...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:59 am
Can I do an upgrade to 32 bit Enterprise and then upgrade to 64 bit Enterprise?..just firing in the air..
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:56 am
Daveee (2/4/2009)
The databases would be in Suspect mode and one has to restart SQL again with added dependencies as you mentioned..
Thanks!!
Unless he is talking about a backup drive or a...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:53 am
Hey Steve..can we have something like 'BUMP' :P( bring up my post) as in facebook to make sure our valuable posts are not lost in the dungeon..
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:49 am
Daveee (2/4/2009)
Make sure all your clustered disks are added as dependencies. If the SQL resource comes online before the physical disk does,...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:44 am
Team lead..Manager..CTO..CFO..Director..as long as everything is up and running...
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:41 am
yulichka (2/4/2009)
Thank you very much, But will it kill my process?
Once you are done with running the script I gave all other processes will be gone. And then you can...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:16 am
This can be achieved in a simple way by setting up alerts..
Go to Management Studio-->SQL Server Agent-->Alerts--> New Alert--> Give whatever name you want and specify severity 17 ( which...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:14 am
Your problems looks familiar to one of others I saw in this forum. Refer to this link, it might help you.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 4, 2009 at 9:06 am
Viewing 15 posts - 211 through 225 (of 469 total)