Did you try to run tail log back up?

As GSquared said, See you have an Identity column it gives the order you entered until unless you specify what order you want result set.

EnjoY!

I forgot to mention, that is first thing you should try to do when if there is something wrong with database, thanks Steve.

EnjoY!

As Wayne said it could be number of reasons, check event logs.

EnjoY!

If this is in production and you have good backups do the restore from Full and T logs back ups.

EnjoY!

Are you taking backup to network drive? If so does this machine has access to network folder?

EnjoY!

Run osql -L in command prompt on either publisher or subscriber machine and see the list of SQL server instances in that domain. You will be able to set...

Server team has to do that, i guess you won't have permission to that, they can add the servers to domain. Don't you have test environment in your office to...

I don't think it is over yet, lets wait for OP 😀

EnjoY!

phanatico-1156717 (2/16/2010)

---

well publisher is in an local network in an office, suscriber its on my home, i made the suscription via (VPN) the two servers are in the same NETWORK...

Are these servers in same domain?

EnjoY!

Are both servers running under local system account?

Machine name and domain name are not the same, Are doing this in your local machine? under which service account your SQL Server is running?

Create another System admin login account and try to login with newly created login account, restore should work.

From BOL

SQL Server prohibits running parallel queries or commands with the DAC. For...

Why do you want to restore mater DB? Script out logins and move them to new instance. Best practices is not to restore system databases.

Enjoy!