December 17, 2008 at 6:31 am
Hi,
After full backup of a database, I want to get transaction log backup and restore to another server?
But there will a new data loss when last transaction backup up to now?
How can i prevent this data loss?
Do you have any idea about tail backup?
December 17, 2008 at 6:39 am
Not sure what you are asking exactly, but assuming you are in full recovery mode you shouldn't lose data by taking a log backup.
I would suggest reading up on backups in books online before you go much farther.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/09a6e0c2-d8fd-453f-9aac-4ff24a97dc1f.htm
The Redneck DBA
December 17, 2008 at 6:40 am
Sorry, a little confused by what you are asking, but I'll try to answer this as best I can.
You are performing a full database backup, then restore this on another server.
From that point you want to take log backups and apply them on the restored copy?
Is this to migrate an existing database to a new server, or to setup logshipping?
December 17, 2008 at 7:29 am
I want to migrate an existing database to anther server,
Not log shipping
December 17, 2008 at 7:33 am
Do you have a limit as regards the downtime you can have associated with the database? ie could you shut down any and all things using the database and have downtime for as long as it requires for you to perform a full backup, copy and restore?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply