March 12, 2009 at 8:04 am
Hello
I am bit confused why do we take database backup with append option, since it will not take a backup of your current database objects. For e.g. I took a backup of a database with append option and later on again I took a backup of the same database after adding some tables on it. Then I restore the latest backup file in a new database, on a new database I saw only the old information, i didnt see the new object that I added. why is that.
March 12, 2009 at 8:06 am
Please post the code you used for both your backups and restores.
March 12, 2009 at 8:08 am
I did a backup and restore with enterprise manager tool. not with a code
March 12, 2009 at 8:09 am
When you do a backup with append, you are writing a new backup set to the end of the same file. When you restored you probably did not specify a backup set, so you got the default, the first backup set in the file.
It is better to do backups to a new file every time to make them easier to manage.
March 12, 2009 at 8:12 am
Okay you mean that I need to create separate backup files while doing backup with append option. if it is hten can you please explain me why
March 12, 2009 at 8:22 am
Yes, you really should do each backup to a separate file. If you are appending backups to the same file you have to specify which file to restore from when doing the restore. This is why I asked for the code. If you were to script your restore, it would include the FILE = 1 (or 2, or 3,...) depending on which backup file you wanted to restore.
March 12, 2009 at 8:27 am
The script that you send is for restoring from a single backup file or multiple backup files. Since I am backing up in a single file with append option. So I need a script for a single file.
thank you
March 12, 2009 at 12:14 pm
You should read about the restore command in SQL Server 2005 Books Online.
http://msdn.microsoft.com/en-us/library/ms178615(SQL.90).aspx
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply