Backup problems

Hi all !!
Last week I made a backup of a database since we need this database to be re
stored on a different server.
To do the backup I used Backup tool included in SQL (right click on databas
e / All tasks / Backup Database ). Backup was made with default options (ap
pent to media checked as well).
The backup file was 1,7 GB size and I decided to compress it in order to bei
ng 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 databa
se, they recover an older version from 3 weeks ago.
I wonder if this problem could be caused because I didn't check overwrite me
dia 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 pro
perly or that I should use other different tool from SQL one.
Thanks in advance !
MiguelMost 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
>