Solved

SQL backup and restore not possible

Posted on 2014-09-18
2
177 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 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 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 26

Accepted Solution

by:
Zberteoc earned 250 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
OfficeMate Freezes on login or does not load after login credentials are input.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now