|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Restore database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Chan Khin Sin 2002-11-28, 9:23 pm |
| I receive a BAK file from my friend, I would like to use
the BAK file to restore the database but the problem is i
don't have the database which backup from my friend in my
curent system, I try to use the EM to restore the database
and get the following error message:
"Logical file 'filename' is not part of database of
database 'database name'. Use Restore FileListOnly to list
the logical file names"
Please tell me how can I restore a database from a BAK
file which the database previously is not in my server.
Thanks
| |
| Vishal Parkar 2002-11-28, 11:23 pm |
| when you restore a database on the second tab of
the "Restore Database" screen make sure you are giving a
valid path in the FILENAME field of all the files(ie
database file & Log files). if this path is wrong then you
can not restore database. Also make sure "Force to replace
over existing database" option is checked. Precaution has
to be taken that you are not overwriting any exsting
database.
--Vishal.
>-----Original Message-----
>I receive a BAK file from my friend, I would like to use
>the BAK file to restore the database but the problem is i
>don't have the database which backup from my friend in my
>curent system, I try to use the EM to restore the
database
>and get the following error message:
>"Logical file 'filename' is not part of database of
>database 'database name'. Use Restore FileListOnly to
list
>the logical file names"
>
>Please tell me how can I restore a database from a BAK
>file which the database previously is not in my server.
>Thanks
>
>.
>
| |
| Allan Mitchell 2002-11-29, 1:23 am |
| You can auto create the DB on your system if it does not exist when you
restore.
On the first page of the restore dialog type in a new name for the DB.
When you have selected the .bak device to restore from then look on the
Options tab. Make sure the drive it wants to put it to exists on your
system or you can type in a new one.
--
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chan Khin Sin" <kschan@sufsys.com> wrote in message
news:035601c29751$7d610290$8ff
82ecf@TK2MSFTNGXA06...
> I receive a BAK file from my friend, I would like to use
> the BAK file to restore the database but the problem is i
> don't have the database which backup from my friend in my
> curent system, I try to use the EM to restore the database
> and get the following error message:
> "Logical file 'filename' is not part of database of
> database 'database name'. Use Restore FileListOnly to list
> the logical file names"
>
> Please tell me how can I restore a database from a BAK
> file which the database previously is not in my server.
> Thanks
>
| |
| Tibor Karaszi 2002-11-29, 1:23 am |
| Read about the RESTORE HEADERONLY, RESTORE FILELISTONLY and RESTORE VERIFYONLY in Books Online,
and use those commands to understand what is on that backup file.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Chan Khin Sin" <kschan@sufsys.com> wrote in message
news:035601c29751$7d610290$8ff
82ecf@TK2MSFTNGXA06...
> I receive a BAK file from my friend, I would like to use
> the BAK file to restore the database but the problem is i
> don't have the database which backup from my friend in my
> curent system, I try to use the EM to restore the database
> and get the following error message:
> "Logical file 'filename' is not part of database of
> database 'database name'. Use Restore FileListOnly to list
> the logical file names"
>
> Please tell me how can I restore a database from a BAK
> file which the database previously is not in my server.
> Thanks
>
|
|
|
|
|