Viewing 15 posts - 6,961 through 6,975 (of 9,244 total)
dont shrink, just increase the log backup frequency is the message here!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:09 am
anthony.green (7/11/2011)
if so dont power on the sql servers until ad is back online.
our server guys have fallen into this trap many a time,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:08 am
you can increase the frequency of the LS backup job without issues.
You could run the backup job every 15 mins as Gail suggested and the copy and restore jobs once...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 12:59 pm
have you installed the pre requisites onto Windows 2003.
You will need Windows installer 4.5, .NET 3.5 framework and the filestream hotfix for Windows 2003
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 12:53 pm
opc.three (7/9/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 10:38 am
SQLkiwi (7/10/2011)
Perry Whittle (7/10/2011)
surely you mean 1TB tempdb, 1TB log and 1TB data.Yes I meant 1TB, and don't call me Shirley 🙂
😀 😉
Good point Jim on the disk sizes.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 8:29 am
assefam (7/9/2011)
After a month , we will migrate to another powerful server with 16 hard disk.
why not just wait until you migrate to the larger server?
disk configs for 16...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 3:48 am
SQLkiwi (7/9/2011)
RAID 1 configuration would result in 2TB tempdb, 2TB log, and 2TB data (and presumably, OS files).
surely you mean 1TB tempdb, 1TB log and 1TB data.
RAID 0 (Striping)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 3:40 am
The cluster.log file holds detailed information on cluster actions. This file is found in
C:\Windows\Cluster
To check the status of cluster groups and which node they are online on, use the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2011 at 9:26 am
Jonathan Marshall (7/8/2011)
Error messageMsg 954
The database x cannot be opened because it is acting as a mirror database
i am able to change the owner at the principal with no issues,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2011 at 4:01 am
shutting down the Windows OS will gracefully shut down all running processes including SQL Server.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2011 at 3:58 am
Helical Johan (7/8/2011)
I have sql server 2008 in windows server 2008, together 32 bits. The problem is
in the memory. It´s full. I enabled the option: Use AWE to allocate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2011 at 3:57 am
Lowell (7/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2011 at 1:26 am
Best way would be using IPSec to encrypt the traffic between the nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 3:32 pm
This link details permissions required for a domain user account. It's important to remember that as well as local security policy assignments the account needs ACls across various parts of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 3:20 pm
Viewing 15 posts - 6,961 through 6,975 (of 9,244 total)