Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Backup and restore

Author  Topic 

dineshrajan_it
Posting Yak Master

217 Posts

Posted - 2010-03-26 : 02:41:48
i have a db named "Sample" in my server. i have received a Sample.bak from another server. i need to restore in my server how to do.

if had mdf and ldf i would have attached and detached it. since its bak file how to do it.

Thanks in advance

Iam a slow walker but i never walk back

dineshrajan_it
Posting Yak Master

217 Posts

Posted - 2010-03-26 : 02:55:47
i think u can only do this by removing the current db and then implement the restore option. my backup file(.bak) doesnot contain log backup. so when i try to restore with the current db present, i get tail of log not backuped. how to do it.

Iam a slow walker but i never walk back
Go to Top of Page
   

- Advertisement -