Viewing 15 posts - 5,281 through 5,295 (of 9,241 total)
thanks for posting back,
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 9:59 am
thunderousity (7/20/2012)
Windows Server 2008 R2 64bit
8GB Ram
I have installed SQL Server 2008 R2 Enterprise 64bit.
What is the best practise relating to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 9:11 am
ramyours2003 (7/20/2012)
how to add a data file in a primary database when the db is configured mirroring in sql 2008 ?
As I said in my response to your post...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 9:03 am
Since this is SQL server 2005 and theres no mention of clustering, the service account will already be a member of the SQL server local groups on the machine and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 1:11 am
No, databases that are part of an AlwaysOn availability groups are already synchronised so recovery should be fairly quick. AlwaysOn is basically database mirroring on steroids 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 1:07 am
ken.schilstra (7/19/2012)
If I run a full backup, how do I restore it to the instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 2:32 pm
Bobby Glover (7/19/2012)
Is it as I have suggested below.
2 Types of always on
FCI and AO Groups
FCI, modification of clustering which already exists, needs shared storeage or can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 9:08 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 8:57 am
do the filepaths on the mirror mimic the principal server or are the drive\path assignments different?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 8:56 am
Just because the installer will let you install everything to the same box doesn't mean you should 😉
For the SSRS instance, you want to keep all the http traffic it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 6:35 am
Why do you have a requirement for SSRS to be deployed specifically on the cluster?
Deploy the SSRS instance to a dedicated server using the cluster as your database storage...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 3:21 am
They could be using virtual sql servers and relying upon the hyper visor HA capabilities to maintain the system uptime.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 3:16 am
Windows 2003 Std x86 will only support 4GB RAM max, this is a limit of the 32 bit address system. Enterprise edition will allow more RAM due to the PAE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 3:14 am
Mike is correct here, the P2V operation is on a per drive basis and if a database is in use the time period netween the transafer of the data and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 2:49 am
sure, appreciate that, but just to make you aware of how it was and is now
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 2:33 am
Viewing 15 posts - 5,281 through 5,295 (of 9,241 total)