myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Problem Restoing on Local server with SQL Express 2005 Manager Options · View
Jerry Montana
Posted: Monday, October 13, 2008 8:37:13 PM
Rank: Newbie
Groups: Member

Joined: 10/13/2008
Posts: 1
Points: 3
Location: Oakland, Ca
I'm using MyLittleBackup on a hosted server, and I can backup easily and download the file locally. When I try to restore this database to my local system so that I can get the data off if it, it does not work. Using SQL Express 2005, when I try to restore, I always get errors. Firs error was that the path was incorrect. So I created an E drive and put the .bak file in the exact location specified by the error, then I get another error about the log file bing in f:. I don't ahve another file to put there I tried seveal options. What is the recomended method for getting data from the .bak file that I created using MyLittleBackup to my local system??
elian
Posted: Tuesday, October 14, 2008 9:12:07 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
myLittleBackup creates standard SQL backup files, which means you can restore them with your SQL Express Management Studio.

The easiest way is
1. open your management studio
2. login as sa
3. right click on Databases and choose Restore database
4. type the name for a new db
5. Choose from device and select your bak file (the one created by myLittleBackup)
6. check the set to be restored
7. click on the Options tab
8. change the path for the data and log files
9. click ok

Hope this helps
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.