Viewing 15 posts - 5,281 through 5,295 (of 9,244 total)
You should only run checkdb once with data_purity on a pre 2005 database to invoke the flag, this is not necessary on 2005 on as the checks are automatically completed.
Try...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2012 at 1:17 am
Has this database ever produced a clean CHECKDB result?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 10:36 am
dbasql79 (7/20/2012)
Hi Folks,1. Can Multisite clustering work on single node per site? Like Node1 on Site A and Node2 on SiteB provided SAN replication.
Yes it can.
dbasql79 (7/20/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 10:21 am
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
Viewing 15 posts - 5,281 through 5,295 (of 9,244 total)