Viewing 15 posts - 6,676 through 6,690 (of 9,244 total)
verify connectivity between the witness and the mirror and the principal and the mirror.
You need to get the session resumed as quick as possible as the log will keep on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 11:16 am
gmamata7 (9/2/2011)
1. Can we rename the Mount Points after installing SQL Server?
already commented on this 😉
gmamata7 (9/2/2011)
2. How to get the Free space, used space for Mount Points?
go into explorer...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 9:59 am
you need to get the configuration right from the outset otherwise you're setting yourself up for a fall from a great height :exclamationmark:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 9:08 am
OK, firstly why is the disk dynamic. Personally i think they should be outlawed 🙂
They're only really useful if you have no hardware RAID system and wish to create a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 9:05 am
praveen.singh (8/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 7:54 am
This I think is your problem
SET DatabaseName = db_name(db_id())
You're setting every single row in your temp table to database name of master (or whatever conext you run the query under)....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 3:41 am
gmamata7 (9/1/2011)
we have the best practice for Optimum performance to have data files asnumber of database data files should equal the number of cores per CPU socket
you shouldnt blindly...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 3:02 am
gmamata7 (9/1/2011)
Method1:Have only one root Drive and have all Mounts Points under that drive
sort of, but i think you are confused with how mount points work. The whole point of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 2:33 am
BigSam (9/1/2011)
In Services & Applications, right-click SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 8:56 am
Failover is not just associated to the heartbeat. The Public connection is also taken into account. If the public NIC is not responding communications with Live applications will be unavailable...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 5:26 am
if the agents don't exist they must have been removed. I personally would attempt to clean them up using the stored procedure.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 5:15 am
SQL Server creates a clustered index by default on the PK, but its not necessarily the best it depends on the design of your tables. Each scenario is different
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 5:13 am
Jeffrey Williams-493691 (8/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:50 am
have you tried clearing them anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:48 am
harita (8/31/2011)
perry,but there are some scripts i guess i saw some people doing it
If you want to concoct your own scripted LS process that would be viable, either way the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:13 am
Viewing 15 posts - 6,676 through 6,690 (of 9,244 total)