Backup / Restore to a different server

Our main system has maintenance plans in place (including backups) and they
seem to be working.
I am taking a seperate specific complete database backup to restore on
another maching for testing.
I'm backing up to a specific file and have the backup verified.
I copy to file to another machine without error.
I restore it on that machine without error.
Yet here is data that is not there.
What am I doing wrong?
Kyle!What you say is simply impossible. I would make sure you are connecting to
the correct servers for both the backup and restore process.
Andrew J. Kelly SQL MVP
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:uOCKY6rlFHA.2444@.tk2msftngp13.phx.gbl...
> Our main system has maintenance plans in place (including backups) and
> they seem to be working.
> I am taking a seperate specific complete database backup to restore on
> another maching for testing.
> I'm backing up to a specific file and have the backup verified.
> I copy to file to another machine without error.
> I restore it on that machine without error.
> Yet here is data that is not there.
> What am I doing wrong?
> Kyle!
>|||How are you determining the data isn't there? Enterprise Mangler needs a
refresh before it will show newly restored databases. You may have
permission issues that are preventing your account from accessing particular
data within the database? Withoutknowing how you are accessing the data, I
really can't go any further.
Geoff N. Hiten
Senior Database Administrator
Microsoct SQL Server MVP
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:uOCKY6rlFHA.2444@.tk2msftngp13.phx.gbl...
> Our main system has maintenance plans in place (including backups) and
> they seem to be working.
> I am taking a seperate specific complete database backup to restore on
> another maching for testing.
> I'm backing up to a specific file and have the backup verified.
> I copy to file to another machine without error.
> I restore it on that machine without error.
> Yet here is data that is not there.
> What am I doing wrong?
> Kyle!
>|||Just stupidity on my part.
Was restoring an old backup. (Happened to be in a different directory but
have the same name.)
Thanks
Kyle!
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:uOCKY6rlFHA.2444@.tk2msftngp13.phx.gbl...
> Our main system has maintenance plans in place (including backups) and
> they seem to be working.
> I am taking a seperate specific complete database backup to restore on
> another maching for testing.
> I'm backing up to a specific file and have the backup verified.
> I copy to file to another machine without error.
> I restore it on that machine without error.
> Yet here is data that is not there.
> What am I doing wrong?
> Kyle!
>