473,669 Members | 2,386 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Repair or Restore an **Incomplete** SQL 2005 .BAK file

1 New Member
I have a SQL 2005 .bak file that looks to be corrupt. It won't restore using standard gui restore method. The file size looks correct (9.8 GB) but it wont restore. The prior day works but unfortunately this is the one day my server harddrive has completely died. Any way to repair or restore this .BAK and see the data? Inside this database is a single table that may allow me to get my missing day added to my yesterday working database.
Jun 22 '15 #1
2 3103
muslihsadri
1 New Member
First of all make use step by step instruction for restoring sql database by SQL Server Management Studio
1. Open SQL Server 2005 Management Studio.
2. Connect to the appropriate server.
3. Expand Databases.
4. Right-click the desired database, mouseover Tasks, mouseover Restore and select Database.
5. The Restore Database window will appear.
6. Ensure that the correct database name appears in the To database field. If not, select it from the dropdown.
7. Under Source for restore, select the From device radio button.
8. Click the button next to the textbox to select the device to restore from.
9. The Specify Backup window will appear.
10. Click Add and locate and select the backup file from the Locate Backup File Window. Click OK.
11. Under Select the backup sets to restore, select all three backups (full, transaction log, and differential).
12. In the left pane, select Options.
13. Under Recovery state, ensure that the Restore with Recovery radio button is selected.
14. Click OK to begin restoring the database.
15. Once the restore is complete, a notification box will appear. Click OK to close the box. You have now restored your database to the most recent state.
Jun 25 '15 #2
loganrush
1 New Member
In case nothing helps read http://answers.unity3d.com/questions...-database.html it might assist
Jun 29 '15 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2308
by: Umar Farooq | last post by:
We have a production server and a bunch of development servers. The Production server is located in a NOC (Network Operations Center) facility and is physically unaccessible on a regular basis. There are DTS packages on the production server which we'd like to pull down to our Dev servers. I was able to save the DTS package to a file and downloaded it to our Dev Servers. But how in the world do I restore it?? I'm a fairly technical...
11
4957
by: ritenah | last post by:
I am running this command from a .bat file. "C:\pathToAccess\MSACCESS.EXE" "C:\pathToDatabase\db.mdb" /REPAIR Database repairs as expected, then shows the messge: "Successfully repaired the ..." and you have to click "Ok" to get rid of the message so that the database can close. How does one suppress this message, so that the database shuts down
2
3572
by: PFI | last post by:
Hi, I recently installed SQL Server 2005 Enterprise Edition (9.0.1399) and I have problems on queries concerning system file manipulation... For example, when I try to increase the Log File of MSDB database : ALTER DATABASE msdb MODIFY FILE (NAME = 'MSDBLog', SIZE = 50MB)
0
2513
by: Lyle Avery | last post by:
Hi guys, An uninstall of a previous version of Visual Studio, or anything (3rd party dev tools)else happen to unregister these (VS 2005) file extensions. I've tested the ˇ°Restore File Associationsˇ± button in Tools->Options->General, but no effect. Who know why? And then, how to restore these file associations without Repair the whole product? Please help me, thanks in advance! So quirk issues...
1
1337
by: Lyle Avery | last post by:
Hi guys, Who knows how to restore VS 2k5 file associations, I've clicked Tools->General->"Restore File Associations" button but it doesn't work at all. I know Repair the whole product could fix it, but it costs too much time. So, if anyone could fix this issue please tell me asap. Any suggestions would be appreciated! Thanks in advance.
1
2723
by: sawtooths | last post by:
Hello, Yesterday at 2pm I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can't take this long. Does anyone know what I can do??? I need to get this database back up, even if it is the version before the restore. Any help ASAP would be appreciated!! Thanks so much.
2
7436
by: pradeep c | last post by:
Currently, I am having a backup file of MSSQL server 2005 database. I want to restore the backup file(of MS Sql server 2005) to MYSQL database. Please Note: I don't have MS sql server 2005 database. How can I do it?
1
1328
by: madan agarwal | last post by:
HI All, I have one database that cantain 10 primary file(.mdf and .ndf) and out of it 1 file get corruptted. My backup shedule: Full backup in sunday day at 7 PM. And differential backup at every 12 hour. Now i have to restore only one corrupted file.So what the best method to do it.
5
2395
by: praveenss | last post by:
I have to write a program where we get the xml file incrementally. i.e the file is constantly updated in the form of xml feed. Thus the first chunk will not be a well formed xml document. However i need to parse the feeds regularly and display the parsed result. How can this be achieved.? Eg... xml field can be following First chunk is as follows: We can see it is not well formed <xml>
0
1867
by: Fragus | last post by:
Trying to import postgresql file around 8GB using pg_restore but it's outputting an error message: pg_restore -d testdb -U postgres -C helium-20141009.sql pg_restore: input file does not appear to be a valid archive
0
8465
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8383
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8588
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8658
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5682
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4206
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4386
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2797
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2032
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.