Viewing 15 posts - 2,146 through 2,160 (of 9,253 total)
MotivateMan1394 (5/5/2015)
But some say the "NT Service\MSSQLSERVER" is more securable for servers that work on internet
These are essentially local accounts and unless you've configured certificated authentication you won't be able...
May 8, 2015 at 9:11 am
MotivateMan1394 (5/6/2015)
HiI want to setup HA
Read through my stairway to alwayson on this site starting at this link
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...
May 8, 2015 at 9:04 am
Joy Smith San (5/3/2015)
Does it need to have any rights on...
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...
May 1, 2015 at 6:40 am
Brandie Tarvin (4/30/2015)
So...
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!
May 1, 2015 at 6:31 am
Try this
Where L.resource_database_id = DB_ID('DBA_HOME')
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
April 30, 2015 at 10:39 am
Andre Carrier (4/29/2015)
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...
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...
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...
April 30, 2015 at 6:34 am
Viewing 15 posts - 2,146 through 2,160 (of 9,253 total)