Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 03:14

  • Please register to post and access all features, it's quick, easy and FREE!

 

Unable to restore db's

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2014
Posts: 319
Received Thanks: 75
Unable to restore db's

I saved them just as I was told to in another thread by Joe and now I cant restore them.

You must register and activate your account in order to view images.

When I backed them up it didnt save them as .bak or .tm so I went and changed one to .bak thinking that was the reason but I still get the same error.

Any ideas as to a fix, if not Im ****** and will need fresh db's if anyone is willing to toss them my way.



IncognitoOne is offline  
Old   #2
 
elite*gold: 0
Join Date: Jul 2014
Posts: 278
Received Thanks: 50
Unfortunately can't see your screenie.

can you describe the exact procedure you are using to restore? Restoring databases on MSSQL is really tricky and messy.

If need be we can link up via skype / teamviewer in PMs I can get you fixed


Banana Bandit is offline  
Old   #3
 
elite*gold: 0
Join Date: Feb 2014
Posts: 319
Received Thanks: 75
I pm'd you and not sure why lightshot link wouldnt show.
IncognitoOne is offline  
Old   #4
 
elite*gold: 0
Join Date: Dec 2012
Posts: 200
Received Thanks: 23
This problems come from the fact that you are trying to restore a DB that does not Exist yet. If that's the case please read below. Otherwise i may have misunderstood you

1. You could back up the database normaly as task -> backup -> database. But here comes the tricky part. You cant just task -> restore them . You need to re-create them.
Meaning the easiest way is to just create new empty DB -> name it RohanGame and then restore your back up to this empty DB. And repeat that for every DB. This is the non-conventional method i used before.

2.Other method is to script the DB along with tables and procedures and data .. etc. Then a Query File is created and you can execute it in your fresh MSSQL. You can read more about that in Microsoft Forums and help guides. There is a wizzard that guides you thru the creation of this file.

I prefer the second method cause you can avoid alot of problems that come with restoring non-existant DB. Since the 2nd method is actually re-creating the db from script you can avoid some nasty Microsoft Bugs with restoring.


asmodeus812 is offline  
Old   #5
 
elite*gold: 0
Join Date: Jul 2014
Posts: 278
Received Thanks: 50
If they were backed up they can be restored even if they don't exist - i've done it a few several times.

The procedure is ****-ugly but do-able via the GUI tools.
Banana Bandit is offline  
Old   #6
 
elite*gold: 0
Join Date: Dec 2012
Posts: 200
Received Thanks: 23
Quote:
Originally Posted by Banana Bandit View Post
If they were backed up they can be restored even if they don't exist - i've done it a few several times.

The procedure is ****-ugly but do-able via the GUI tools.
Yes You can do that with the GUI. But imo the easiest way is just to create an empty DB and just restore it. As i said i prefer scripting the db anyway !


asmodeus812 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Buying] RESTORE MMR
Hello im looking for duoq to restore my mmr im gold v 224wins 224 loses im getting 10lp/game and losing like 20 pm me how much Edit: EUW server
6 Replies - League of Legends Trading
[Buying] restore MMR
i got an account that is GOLD V, and get like 7-8-10 lp, and lose 20 lp.. 225 wins - 230 losses How much would cost to restore the MMR in DUOQ? ...
1 Replies - League of Legends Trading
i can t restore db with new
i try to restore my old db with the new in the pack but it it is like they are empty: http://i.epvpimg.com/IZ5Dh.jpg
6 Replies - Rappelz Private Server
Restore HP,SP
how to restore HP and SP in player. Like GM command "/r" but in Quest.
4 Replies - Metin2 PServer - Discussions / Questions
acc restore
anyone have or know how to get to the page where u can restore accs? search but only came up with a scam thread
3 Replies - CO2 Main - Discussions / Questions



All times are GMT +2. The time now is 03:14.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.