Viewing 15 posts - 2,146 through 2,160 (of 9,244 total)
MotivateMan1394 (5/6/2015)
HiI want to setup HA
Read through my stairway to alwayson on this site starting at this link
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2015 at 9:06 am
magnus.tengmo (5/8/2015)
I got 5 SQL Servers 2008R2 (2x CPUs with 96-384Gb of RAM) with total 1500DBs and around 10Tb of allocated data. Now I´m forced to upgrade to 2012 and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2015 at 9:04 am
Have you read my stairway??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2015 at 11:53 am
Joy Smith San (5/3/2015)
Does it need to have any rights on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2015 at 11:34 am
dick.vanderweed (5/1/2015)
Choosing Server type: Database Engine with the Server name default value "(local)"
If you performed a default install of express then the engine will be a named instance.
Open up the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2015 at 6:40 am
Brandie Tarvin (4/30/2015)
So...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2015 at 6:32 am
EMarkM (5/1/2015)
When that "reason" happens again (tomorrow's new data load for example)
or an index rebuild!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2015 at 6:31 am
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2015 at 11:03 am
Try this
Where L.resource_database_id = DB_ID('DBA_HOME')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2015 at 10:44 am
Steve Jones - SSC Editor (4/30/2015)
- encrypts certificate in master (can be multiples here for different dbs)
It encrypts the certs private key whilst it is stored on the server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2015 at 10:39 am
Andre Carrier (4/29/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2015 at 6:56 am
you can create a failover cluster instance on a cluster with 1 node that's fine, not much use but can be done.
For AlwaysOn availability groups you will need at least...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2015 at 6:52 am
ninad.soman0 (4/30/2015)
Yes, you will have to copy the certificates and keys from both the prod servers to the DEV box.
Incorrect, you do not need the DMK from server a and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2015 at 6:47 am
RamSteve (4/30/2015)
Hi ,I would like to know what happens if i shrink the database with truncate only option and do a full backup or transaction log backup ?
with the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2015 at 6:34 am
Andre Carrier (4/29/2015)
- install an initial sql 2014 test clustered instance
- test a migration by scripting logins, jobs, security, ssis etc. then backup-restore or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2015 at 10:25 am
Viewing 15 posts - 2,146 through 2,160 (of 9,244 total)