August 27, 2015 at 9:05 am
I have a scenario wherein I get a Initial Full backup of a database and only log backups following that on a schedule (only the initial full backup and no more full backups).
I need to maintain a copy of that database on another server offsite that can be queried upon. The restores need to happen automatically from the folder which I got through. The issue that I have is to have the database both usable and capable of getting more log backups. If I try to recover those log backups using RESTORE WITH RECOVERY, I cannot restore any more log backups. If I use RESTORE WITH NORECOVERY, I cannot query the database.
Can someone advise on how I should go about? This is actually not one database. This is for more than one database from either SQL 2008 or SQL 2008 R2 and have to be restored on SQL 2008 R2 or up.
I was trying to go with STANDBY but then if the sql versions are different, that would not work out. I have 2008 and 2008 R2 at source and only one server offsite which could be any version from 2008 R2 & up. Appreciate any help on this.
August 27, 2015 at 9:23 am
If you're got disparate versions, backup/restore isn't going to work for what you want. Try transactional replication.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 27, 2015 at 9:36 am
They are not in the same network ( 2 different offices - one hosting the product and database and other the customer using the product) and they cannot be linked as well. If I make them both 2008 R2, would the STANDBY option work? Do the servers need to be at the same level when it comes to updates and service packs? My first preference is not to go with just 2008 R2. But if that is not possible at all, then I can go with 2008 R2 on both sides.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply