Backup problems

Hi all !!
Last week I made a backup of a database since we need this database t
be restored on a different server.
To do the backup I used Backup tool included in SQL (right click o
database / All tasks / Backup Database ). Backup was made with defaul
options (appent to media checked as well).
The backup file was 1,7 GB size and I decided to compress it in orde
to being able to burn a CD and send it, the compress file was 250 MB s
I burnt a CD with compress database and sent it.
My problem is when the guys where the other server is allocate
restored the backup they could do it but didn't recover the newes
version of the database, they recover an older version from 3 week
ago.
I wonder if this problem could be caused because I didn't chec
overwrite media option (and I check append to media option) from SQ
backup tool or this can be caused for any other reason like the
weren't able to recover it properly or that I should use othe
different tool from SQL one.
Thanks in advance !
Migue
-
Miguel Ange
----
Posted via http://www.webservertalk.co
----
View this thread: http://www.webservertalk.com/message200843.htmMost 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
>