Viewing 15 posts - 6,001 through 6,015 (of 26,490 total)
kaplan71 (8/25/2014)
So what you are saying is that if that one backup file goes corrupt or missing you lose the backups for ALL your databases.
That is incorrect.
To...
August 25, 2014 at 1:06 pm
rwaring 96203 (8/25/2014)
August 25, 2014 at 12:40 pm
jjturner (8/25/2014)
Lynn Pettis (8/25/2014)
August 25, 2014 at 12:38 pm
Oh, and then we have the one backup routine for them all and all to one file. Oh, help me because this process has gone from running 1 hour...
August 25, 2014 at 12:35 pm
kaplan71 (8/25/2014)
Hello --The backups are run under one subplan that backs up every database to a individual bak file.
So what you are saying is that if that one backup...
August 25, 2014 at 12:34 pm
Oh dear, the backup process for the production database is changing the recovery model of the development database. Help me.
Really?? When did the The Thread start taking over peoples...
August 25, 2014 at 12:14 pm
Backup processes will not change the recovery model of a database. The only way this can happen is if someone goes in and manually modifies the recovery model using...
August 25, 2014 at 12:11 pm
TomThomson (8/25/2014)
CELKO (8/19/2014)
>> ......
And while I'm asking "why", why don't you conform to this website's quote tag norm instead of doing something completely different?
Could it be that this sites quote...
August 25, 2014 at 12:00 pm
Is this a single job backing up each database one at a time?
August 25, 2014 at 10:56 am
Eirikur Eiriksson (8/25/2014)
CELKO (8/19/2014)
This is called a hash function. You can Google it or get a book on freshman computing, or data structures.
Out of curiosity, isn't this a slight...
August 25, 2014 at 8:15 am
kenn3th.w0ng (8/25/2014)
Key point - proof of concept. We got to start somewhere.
So what's the difference between SELECT COUNT(*) FROM someschema.sometable and SELECT @@SERVERNAME? Both will provide proof of concept...
August 25, 2014 at 8:11 am
kenn3th.w0ng (8/25/2014)
August 25, 2014 at 7:55 am
kenn3th.w0ng (8/25/2014)
The idea...
August 25, 2014 at 7:37 am
Jeff Moden (8/24/2014)
Steve Jones - SSC Editor (8/24/2014)
You don't want to do...
August 24, 2014 at 9:36 pm
dwain.c (8/24/2014)
But for some reason...
August 24, 2014 at 9:25 pm
Viewing 15 posts - 6,001 through 6,015 (of 26,490 total)