Viewing 15 posts - 1,081 through 1,095 (of 9,244 total)
you'd have to break the mirror and re initialise it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 10:31 am
Luis Cazares (11/10/2016)
The improvement on window functions and error handling.
Native compressed backups, which would speed up your maintenance process.
Extended events to mostly replace traces.
New cardinality estimator.
Improved...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 10:29 am
log backups are not encrypted at this version unless TDE in use or using 3rd party backup solution.
SQL 2014 offers encrypted backups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 10:03 am
josh-1127203 (11/10/2016)
If that's the case, what is the best approach to deal with this type of situation? I use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 10:01 am
ramyours2003 (11/9/2016)
I would like to know the t-log grow as the databases are in simple recovery , how can we calculate the growth of transaction log file ?
as already discussed,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 8:11 am
ramyours2003 (11/9/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 8:04 am
see
https://msdn.microsoft.com/en-us/library/ms191233.aspx
https://msdn.microsoft.com/en-us/library/ms178117.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 7:57 am
is this an asynch or synch mirror session, is there a witness present?
What in particular are your team reporting a mismatch on?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 6:16 am
alex.sqldba (11/8/2016)
I have a database, with a filegroup that is 2TB of documents (blob data).
I frequently have restore this database elsewhere, for various reasons that are mostly sub-optimal, but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 6:14 am
szejiekoh (11/9/2016)
Perry Whittle (11/8/2016)
szejiekoh (11/8/2016)
how do we prevent data generated in the mirror from syncing back to the previous principal ?
why on earth do you want the synch to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 6:07 am
szejiekoh (11/9/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 6:04 am
marcjell (11/8/2016)
I am building entirely within Azure. I spun up two...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 10, 2016 at 5:59 am
szejiekoh (11/8/2016)
how do we prevent data generated in the mirror from syncing back to the previous principal ?
why on earth do you want the synch to stop??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2016 at 12:16 pm
most common reason ive seen for node dropping out of the cluster is co-stop on the ESX host, but normally get a different message.
What is the current status on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2016 at 12:14 pm
a DW is not designed to be a complete replica of all your data, well at least it shouldn't be anyway!
The warehouse is used for storing and presenting data to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2016 at 4:49 am
Viewing 15 posts - 1,081 through 1,095 (of 9,244 total)