Viewing 15 posts - 2,146 through 2,160 (of 9,703 total)
Sean Lange (11/18/2015)
Jack Corbett (11/18/2015)
Phil Parkin (11/18/2015)
Jack Corbett (11/18/2015)
November 18, 2015 at 1:05 pm
When the witness does not exist and the primary goes down, I believe mirroring will be broken and you have to manually make the mirror DB the primary.
I know when...
November 18, 2015 at 7:44 am
May I also point out that NOT IN vs IN is a different matter than NOT LIKE and LIKE?
NOT IN and IN only consider whole value comparisons where NOT LIKE...
November 18, 2015 at 7:41 am
Or, instead of dropping temp2, change the second "INTO temp2" to an "INSERT INTO temp2 (column list)" like you did with temp_p.
November 18, 2015 at 7:40 am
robert.sterbal 56890 (11/18/2015)
Luis Cazares (11/18/2015)
November 18, 2015 at 7:37 am
GilaMonster (11/18/2015)
Brandie Tarvin (11/18/2015)
tripleAxe (11/18/2015)
Striping the backup to multiple backup files can help you reduce the backup/restore time.
In my experience, I have seen no difference between restoring striped files...
November 18, 2015 at 5:31 am
Jeff Moden (11/17/2015)
November 18, 2015 at 4:33 am
jbrandenburg (11/17/2015)
How is this configuration option completed? What is the impact of doing so?
Which configuration option are you talking about?
Have you gotten with the server admin to run a...
November 18, 2015 at 4:30 am
tripleAxe (11/18/2015)
Striping the backup to multiple backup files can help you reduce the backup/restore time.
In my experience, I have seen no difference between restoring striped files and a single...
November 18, 2015 at 4:26 am
K. Brian Kelley (11/17/2015)
The most overlooked area: "soft skills."- How clearly you can communicate.
- How well you work with others.
- How organized you are.
Yes. And emotional intelligence is probably the...
November 17, 2015 at 11:40 am
djj (11/17/2015)
Lynn Pettis (11/17/2015)
OMGResume time.
Not touching that one with a ten foot pole.
Someone is probably getting fired.
November 17, 2015 at 11:38 am
Send some of that snow my way, Steve?
November 17, 2015 at 11:38 am
If you only need to restore once every two weeks, then restoring off the production backups (as Gail suggested) is your best bet.
Create a T-SQL job that is scheduled...
November 17, 2015 at 10:31 am
As Anthony said, you need to talk to the person providing these backups to you.
EDIT: To be clear, unzipping a file does not "create" a backup file. What's happening is...
November 17, 2015 at 8:42 am
GilaMonster (11/17/2015)
November 17, 2015 at 6:24 am
Viewing 15 posts - 2,146 through 2,160 (of 9,703 total)