Viewing 15 posts - 6,961 through 6,975 (of 9,241 total)
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
arvind.1611 (7/8/2011)
@perry: Then suggest a better way out..
I already have, see above and below
Perry Whittle
To replicate a complete database, I would use either log shipping or database mirroring.
arvind.1611 (7/8/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 10:01 am
Jonathan Marshall (7/8/2011)
exec sp_changedbowner 'sa'
as you're not using a USE statement, what database focus did you have set for the query window?
also did the user account exist on the mirror...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 7:54 am
what was the command you used to do this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 7:43 am
Viewing 15 posts - 6,961 through 6,975 (of 9,241 total)