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??
|
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
|