Viewing 15 posts - 331 through 345 (of 4,745 total)
DBA-640728 (1/27/2014)
January 27, 2014 at 12:00 pm
A rule of thumb is run them often enough so you can recover quickly if corruption found, so if you keep 3 days worth of backups on the server, run...
January 27, 2014 at 9:16 am
I'm guessing the Hyperbac tool is Redgate's version of Litespeed engine for sql server, i haven't used SQLBackup for a while now as all my previous contracts have been Quest...
January 27, 2014 at 9:06 am
Perry Whittle (1/27/2014)
george sibbald (1/27/2014)
ah, I see. Its a personal preference but I don't like having a layer of obfuscation between me and my backups.
A personal preference which i'm sure...
January 27, 2014 at 8:19 am
ah, I see. Its a personal preference but I don't like having a layer of obfuscation between me and my backups.
having said that we use hyperbac where we need encryption...
January 27, 2014 at 6:45 am
Perry Whittle (1/27/2014)
Given the relatively low cost of licences for these products, they make excellent sense and IMHO are more flexible than native backups 😉
other than encryption, what makes you...
January 27, 2014 at 6:18 am
yes, thats a fairly common method used to do migrations or any move of server. Restore the full with norecovery and when ready for cutover, do a diff or log...
January 25, 2014 at 10:11 am
of course, it depends how many small tables you've got. 😉
January 24, 2014 at 3:23 am
firstly those results are for the total of data and log files, so how big is each?
the reserved value is of more interest
January 23, 2014 at 9:58 am
script enclosed I used when migrating databases from 2000 to 2008 by backups
/*****************************************************************************************/
/* this generic script restores a SQL 2000 database backup into a SQL 2008 instance, ...
January 23, 2014 at 9:20 am
Toreador (1/23/2014)
Interesting question, but the title meant it was easy to get the right answer.Though it looks like almost half the people who answered didn't read the title 😉
count...
January 23, 2014 at 6:26 am
other than the obvious you understandably don't want to use, I don't know of a way. There may be a trace flag to change this behaviour.
January 22, 2014 at 5:05 pm
copy_only full backup is only relevant to differential backups, as they do not reset the LSN base for the differential.
You can start from the friday 10pm backup and do a...
January 22, 2014 at 3:41 pm
You need to prevent it from repeatedly trying to connect to SQL. this could even be a hacking attempt. The login failure message should give an ip address for the...
January 22, 2014 at 3:34 pm
There are not major differences between these two versions, but they are different, so you would have to test that all your apps work the same, and are compatible with...
January 22, 2014 at 3:29 pm
Viewing 15 posts - 331 through 345 (of 4,745 total)