Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 9th, 2007, 09:16 AM
Registered User
 
Join Date: Jul 2007
Location: , , USA.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sivap
Default 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

Reply With Quote
  #2 (permalink)  
Old July 9th, 2007, 12:30 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old July 12th, 2007, 02:18 PM
Registered User
 
Join Date: Jul 2007
Location: , , USA.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sivap
Default

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

Reply With Quote
  #4 (permalink)  
Old July 12th, 2007, 04:28 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old July 13th, 2007, 08:45 AM
Registered User
 
Join Date: Jul 2007
Location: , , USA.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sivap
Default

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

Reply With Quote
  #6 (permalink)  
Old July 13th, 2007, 08:51 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to restore a local backup? mugwomp SQL Server 2005 2 September 6th, 2007 02:31 PM
Backup and restore in ASP. rupen Classic ASP Databases 5 August 12th, 2005 03:36 PM
Backup restore error Prabhakar_dt Classic ASP Basics 1 July 21st, 2005 07:20 PM
Backup and Restore acko SQL Server 2000 0 July 1st, 2004 03:18 AM
How to backup and restore Database phubinh Pro VB Databases 1 June 4th, 2004 03:10 AM



All times are GMT -4. The time now is 04:10 PM.


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