Backup problems

Hi all !!
Last week I made a backup of a database since we need this database to
be restored on a different server.
To do the backup I used Backup tool included in SQL (right click on
database / All tasks / Backup Database ). Backup was made with default
options (appent to media checked as well).
The backup file was 1,7 GB size and I decided to compress it in order
to being able to burn a CD and send it, the compress file was 250 MB so
I burnt a CD with compress database and sent it.
My problem is when the guys where the other server is allocated
restored the backup they could do it but didn't recover the newest
version of the database, they recover an older version from 3 weeks
ago.
I wonder if this problem could be caused because I didn't check
overwrite media option (and I check append to media option) from SQL
backup tool or this can be caused for any other reason like they
weren't able to recover it properly or that I should use other
different tool from SQL one.
Thanks in advance !
Miguel
Miguel Angel
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message200843.html
Most likely you have several backups on the backup file. You can use RESTORE HEADERONLY to check this and then
the FILE option when you perform the restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Miguel Angel" <Miguel.Angel.15dlii@.mail.webservertalk.com> wrote in message
news:Miguel.Angel.15dlii@.mail.webservertalk.com...
> Hi all !!
> Last week I made a backup of a database since we need this database to
> be restored on a different server.
> To do the backup I used Backup tool included in SQL (right click on
> database / All tasks / Backup Database ). Backup was made with default
> options (appent to media checked as well).
> The backup file was 1,7 GB size and I decided to compress it in order
> to being able to burn a CD and send it, the compress file was 250 MB so
> I burnt a CD with compress database and sent it.
> My problem is when the guys where the other server is allocated
> restored the backup they could do it but didn't recover the newest
> version of the database, they recover an older version from 3 weeks
> ago.
> I wonder if this problem could be caused because I didn't check
> overwrite media option (and I check append to media option) from SQL
> backup tool or this can be caused for any other reason like they
> weren't able to recover it properly or that I should use other
> different tool from SQL one.
> Thanks in advance !
> Miguel
>
> --
> Miguel Angel
> Posted via http://www.webservertalk.com
> View this thread: http://www.webservertalk.com/message200843.html
>