[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL backup and restore not possible

Posted on 2014-09-18
2
Medium Priority
?
206 Views
Last Modified: 2014-09-23
Hi Experts,

I have a SQL server 2005 SP4 STD.
I made a backup of the DB to import it on a new server SQL 2012.
The backup was ok.

When I try to restore the DB on the SQL2012 server and I select the file, I cannot select any DB.
Can you help me why ?
0
Comment
Question by:Eprs_Admin
2 Comments
 
LVL 53

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 total points
ID: 40330414
Can you post here a screenshot?
Alternatively you can use SQL command to run a query for restore, which is something that I always prefer:
RESTORE DATABASE YourDBNameHere
FROM DISK = '<Full Path plus Filename.bak>' 
MOVE '<Datafile Logical Name Here>' TO '<Full Path plus Datafile filename.mdf>', 
MOVE '<Logfile Logical Name Here>' TO '<Full Path plus Logfile filename.ldf>'

Open in new window

0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 1000 total points
ID: 40330446
if the database that was backed up doesn't exist on the new server there is no database to choose. Just start the restore following the UI from Management Studio and the database will be created .
0

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question