p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2005 (http://p2p.wrox.com/forumdisplay.php?f=220)
-   -   Need Help - BackUp and Restore (http://p2p.wrox.com/showthread.php?t=59910)

sivap July 9th, 2007 09:16 AM

Need Help - BackUp and Restore
 
Hi All,

   I am new to SQL 2005. i have a backup file in location C:/. i need to restore this in to my local server. I could not select the file from the restore back up location.

Thanks in advance.
Siva


planoie July 9th, 2007 12:30 PM

The server can only work with local files so you need to put the file onto the server drives, then you can select it thru the restore tool.

-Peter

sivap July 12th, 2007 02:18 PM

Thanks for the reply...but i dont get it...What do you mean by Server drives ? How can i do that. Can you explain that to me ?

Thanks,
Siva


planoie July 12th, 2007 04:28 PM

Server drives = the hard drives physically connected to the database server computer. (C:, D:, E: ...)

The file browser in the SQL management studio can not browse to (\\fileserver\files\databasebackup.bak)

Perhaps I'm misunderstanding your original post. Do you mean that the computer that you are sitting at has the backup file (on C:) as well as the instance of the database server you are trying to restore to? This shouldn't be a problem, just navigation to C:\ in the restore tool.

Is the problem that you haven't selected "From Device" in the restore wizard? You need to choose that so you can then select "File" as the device from which you are restoring.

-Peter

sivap July 13th, 2007 08:45 AM

I selected the "From Device" from restore wizard. but i dont see the .bak file in C:/ if i type the file name by myself i am getting an error message saying that ' file is not exist or SQL does not have permission to access to that file. ?

I just have the .bak file.. is that enough to restore ? What about the instance you were mentioned ?

Really appreciate the help.

Thank,
Siva


planoie July 13th, 2007 08:51 PM

If the .bak file was a full backup of a whole database, then it should be enough.

"Instance" refers to the installed instance of the SQL Server database engine.

If the database backup file you are attempting to restore physically located on the database engine server?

-Peter


All times are GMT -4. The time now is 12:28 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.