| Author |
Topic |
|
BlackReefDesigns
Starting Member
27 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 16:08:34
|
| Note the links have no information, please help!Thank you |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-07 : 16:08:43
|
Did you try the suggestion made in the error message?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-07 : 16:15:45
|
Oh! Thanks.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 16:32:36
|
| Tara- Thank you for help.I think Im a bit confused on the GUI screen? I barely started using SQL 2005 client so Im new to it. Basically all I am doing is running server management express inside of my Remote Desktop, and right-clicking on my database and selecting restore, then finding the backup file and using that.Could you direct me on how to get to the GUI screen?Thanks so much for the help... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 17:03:31
|
| Oh, I see.Could you let me know real quick where I can make sure I am only restoring the full backup and not the transaction logs?Thank you Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-01-07 : 17:33:46
|
| I don't have SQL Express installed, so I'm not sure if Management Studio Express looks the same as Management Studio from the other editions. In my client tool, here are the steps:Right click, restore database, specify the database name, select device, navigate to the file, go back to original restore screen, check the box on the backup set to restore, and then options page should have the "WITH RECOVERY" one selected (which should be the default anyway). The key is to not specify a point in time recovery.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 17:41:55
|
| EDIT: I do see the Options screen, and the RESTORE WITH RECOVERY is checked?BTW, here is a Screen Capture of the screen I am on right now:http://www.blackreefdesigns.com/misc/gui1.gif |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 17:48:46
|
| http://www.blackreefdesigns.com/misc/gui2.gif |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-07 : 17:58:14
|
| wow! it actually restored! this is amazing! thank you so much tara, your a lifesaver. Ive been working on restoring this database for over a week now (I wasted ALOT of time trying to do it through my Plesk Control Panel interface, haha)Now I need to figure out why the site is running so slow and I am getting Database errors? (adxtactical.net) Hopefully the virtual server tech support can figure that out.Thank you again Tara!!!!!!!!!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Restoring .bak in Studio Express, got an error....
Tara Kizer