[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Database restore

Posted on 2012-09-13
3
Medium Priority
?
254 Views
Last Modified: 2012-10-02
Hi guys,
I need to restore a database using SQL Server Management...i´ve tried but with no success!
I go to database, right click->restore...then i select the file and hit OK and then i get the error on attach...
Please Help
sql.jpg
0
Comment
Question by:Ercélio Pedro Mabota
  • 2
3 Comments
 

Accepted Solution

by:
sqlsree earned 1500 total points
ID: 38396051
Check out this:

http://msdn.microsoft.com/en-us/library/ms177429.aspx 

this would help you.
0
 

Author Comment

by:Ercélio Pedro Mabota
ID: 38453965
i found out the SSMS on both servers were different...the one i took the backup from was using SQL server 2008, and the one i was trying to restore was using SQL 2005. So i upgraded on the server i was trying to restore and it worked fine.
0
 

Author Closing Comment

by:Ercélio Pedro Mabota
ID: 38453972
i had to dig a little bit more to uncover the solution
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Problem: Windows 32bit running out of paging space. Solution: Add additional page files on separate partitions. Background: By default Windows creates only one page file on the partition you install Windows on. You may know that the maximu…
Have you ever stumbled upon a software that is so great that you just love? It happened to me. Love at first sight. Filezilla Server.   Ok its not the most advanced ftp server I've came across. But its a fairly simple piece of software to get the …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

873 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