Viewing 15 posts - 6,061 through 6,075 (of 9,241 total)
MarkThornton (1/13/2012)
Thanks for helping. I ran Paul's code and got this result:
session_idstart_time status ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 9:27 am
GilaMonster (1/13/2012)
You're posts are not making any sense.
It's not just me then 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 6:19 am
ESAT ERKEC (1/13/2012)
Sorry i want to make fragmention of index about 100
fragmentation should be as low as possible not as high as possible!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 4:51 am
this is a known issue, truncate clears the table as all pages are de allocated. When deletes occur the ghost delete process fires to remove pages, with LOBs this takes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 4:46 am
Do you have any databases mirrored on this instance already or is this the first one you are attempting?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 4:36 am
Ah right ok.
Try switching compression on using the command above see if it throws an error message, this may give a clearer indication.
Can you go to the Transaction log backup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 1:20 am
What version is the secondary?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 1:07 am
garthwaimr27 (1/12/2012)
I was hoping you wouldn't say that : ).What's the purpose of reinstalling the OS on the old node? Could I just reinstall SQL?
Reinstall to get a clean...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 1:04 am
garthwaimr27 (1/12/2012)
1. Just run the cluster setup on the existing server? Can I keep my existing server\instance name if I do this?
No, it doesn't work like that.
garthwaimr27...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 2:17 pm
Least you got it sorted. Time to give the AD admins a grilling.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 1:12 pm
ss-457805 (8/13/2010)
Did...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 7:45 am
GilaMonster (1/11/2012)
Perry Whittle (1/11/2012)
To re attach a database with a missing log file just use either
sp_attach_single_file_db
CREATE DATABASE .... FOR ATTACH_REBUILD_LOG
Which only works if the database was shut down cleanly...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 5:54 am
MarkThornton (1/12/2012)
My current theory is that this isn't working, due to the presence of an ntext field in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 4:28 am
s_osborne2 (1/12/2012)
I let the installer configure with the defaults. Maybe that was my error! 😉Hope to be able to give this another go at some point later today.
I always prefer...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 4:04 am
Chris Shaw (1/11/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 1:18 am
Viewing 15 posts - 6,061 through 6,075 (of 9,241 total)