Viewing 15 posts - 31 through 45 (of 47 total)
Quest Software (previously Imceda) Litespeed now has the Log reader inbuilt in the software. it works very much fine in reading both the online/offline database logs and also the transaction...
August 23, 2009 at 6:42 am
I guess Oracle's strategy would be to stop releasing or supporting any future versions of MySQL, thereby preventing competition from the open-end market for their DBMS products anymore. Microsoft /IBM...
August 17, 2009 at 7:04 am
Steve Jones - Editor (3/3/2009)
Expiredate isn't a delete. It allows rewriting of the file.
does it mean that it will overwrite the space used for the old expired backups with...
March 4, 2009 at 12:56 am
I saw that syntax for BACKUP page in Books online also. Even there it is not clearly specified if the EXPIREDATE will work for disk backups or not. it is...
March 2, 2009 at 11:33 pm
GilaMonster (2/4/2009)
If you take a log backup and don't ship it, you will have a problem. No log backups past that point will restore, saying there are LSNs missing.
Yes I...
February 5, 2009 at 3:54 am
GilaMonster (2/3/2009)
The only time the COPY_ONLY option is necessary is if you are doing differential backups as without that a full backup will reset the differential base.
Full backups never break...
February 4, 2009 at 5:38 am
GilaMonster (2/2/2009)
Why? There shouldn't be any problem. Take full backups daily and write them to tape, set up the log shipping so that it doesn't delete the tran log backups...
February 3, 2009 at 12:19 am
Sakthivel Chidambaram (2/2/2009)
Anyway you are going to configure log shipping which is already a DR then why again Full backup to DR location?
...
February 2, 2009 at 3:28 am
Yes, but actually I need to take backup of those log shipped databases daily, and take them to tape.
I cant take backups from the source server, because if I take,...
February 2, 2009 at 1:47 am
Check if the user's Windows account has administrator privilege in the server in which he is not able to login into SQL. He might have administrator privilege in the other...
January 26, 2009 at 3:04 am
It goes like this..
4194320 = 4194304 + 16
4194304 = autoshrink
16 = torn page detection
4194328 = 4194304 + 16 + 8
4194304 = autoshrink
16 = torn page detection
8 = trunc. log on...
January 9, 2009 at 12:13 am
James and Jerry,
Thanks a lot for the reply. I am now getting prepared to install SP3 directly 🙂
January 9, 2009 at 12:08 am
oh, thats great.. i used the script this way using a variable and then executing it. and i completed my query and it worked great. But I think we cannot...
December 17, 2008 at 5:20 am
Possibly because of weekend maintenance jobs, the log grows and it takes long time to backup this large log file along with the full backup.
October 28, 2008 at 3:49 pm
Differential backup backs up all the changes since the last full backup.
Transaction log backup backs up all the changes made since the last transaction log backup, or since the last...
October 28, 2008 at 3:42 pm
Viewing 15 posts - 31 through 45 (of 47 total)