Friday, February 17, 2012

Create DB from Backup

This is a multi-part message in MIME format.
--=_NextPart_000_000C_01C6A76D.C365CB60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all, is there an easy way to create a Data Base from a Backup file?
I've tried creating the data base and then trying to restore the prevous = backed up data base but I get some errors like "Directory lookup for the = file (the mdf file) failed with the operating system error 3 (The system = cannot find the specified path)"
TIA
-- .seb
http://sgomez.blogspot.com
--=_NextPart_000_000C_01C6A76D.C365CB60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi all, is there an easy way to create = a Data Base from a Backup file?
I've tried creating the data base and = then trying to restore the prevous backed up data base but I get some errors like = "Directory lookup for the file (the mdf file) failed with the operating system = error 3 (The system cannot find the specified path)"

TIA
-- .sebhttp://sgomez.blogspot.com=
--=_NextPart_000_000C_01C6A76D.C365CB60--Do not create the database. Just do a restore. On the Restore database
window select Options and make sure that the Restore As column shows a valid
path and that you have permissions on it.
Ben Nevarez, MCDBA, OCP
Database Administrator
".seb" wrote:
> Hi all, is there an easy way to create a Data Base from a Backup file?
> I've tried creating the data base and then trying to restore the prevous backed up data base but I get some errors like "Directory lookup for the file (the mdf file) failed with the operating system error 3 (The system cannot find the specified path)"
> TIA
> --
> ..seb
> http://sgomez.blogspot

No comments:

Post a Comment