file backup

30 Sep 2005 7:19 AM

Joe

Since i backup a database with file backup option, then i delete the database
, then i use the file to restore, it can't, why

30 Sep 2005 7:22 AM

Mike Epprecht (SQL MVP)

What error are you getting?
What T-SQL code are you using to do the restore?

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quote

"Joe" <J**@discussions.microsoft.com> wrote in message
news:7744447D-0F3E-41BD-A723-19D1CEECB866@microsoft.com...
> Since i backup a database with file backup option, then i delete the
> database
> , then i use the file to restore, it can't, why

30 Sep 2005 1:02 PM

JT

So your method of performing backups is to copy the the .mdf (database) and
..ldf (transaction log) files? If so, then you need to read up on 'attach'
and 'detach'. You may also want to also backup the master database as well,
becuase it contains the login information and other important meta data
needed by the application databases.

Attaching and Detaching a Database
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_89pv.asp
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133/

Show quote

"Joe" <J**@discussions.microsoft.com> wrote in message
news:7744447D-0F3E-41BD-A723-19D1CEECB866@microsoft.com...
> Since i backup a database with file backup option, then i delete the
> database
> , then i use the file to restore, it can't, why