|
You last visited: Today at 12:12
Advertisement
SQL database restore problem
Discussion on SQL database restore problem within the SRO Private Server forum part of the Silkroad Online category.
10/11/2012, 20:32
|
#1
|
elite*gold: 0 
Join Date: Oct 2008
Posts: 12
Received Thanks: 1
|
SQL database restore problem
Hi! I have a prob. with restoring database (SRO_VT_ACCOUNT/SHARD/SHARDLOG). When i trying to restore these files, i cant find the .bak files in my computer. I tried to reinstall the program, and i started a searching for those files, but no results. Can somebody help to fix this problem?
Thank you!
|
|
|
|
10/11/2012, 21:01
|
#2
|
elite*gold: 0
Join Date: Oct 2011
Posts: 1,101
Received Thanks: 353
|
just make a new db... like a new dl a new database and restore it.
|
|
|
|
|
10/11/2012, 21:08
|
#3
|
elite*gold: 0
Join Date: Oct 2008
Posts: 12
Received Thanks: 1
|
I tried that too. I deleted the files, then i started it again but still nothing...Dont know why...it should be in C: but nothing.
|
|
|
|
|
10/11/2012, 21:34
|
#4
|
elite*gold: 0
Join Date: Aug 2012
Posts: 110
Received Thanks: 110
|
I had the same problem. Put it in D: or something else and try it again.
That worked for me ^^
|
|
|
|
|
10/12/2012, 00:27
|
#5
|
elite*gold: 0
Join Date: Nov 2011
Posts: 89
Received Thanks: 81
|
make able to see every kind of file extension not only .bak files,this might help
|
|
|
|
|
10/12/2012, 11:11
|
#6
|
elite*gold: 62
Join Date: Mar 2011
Posts: 602
Received Thanks: 2,955
|
|
|
|
|
|
10/12/2012, 19:06
|
#7
|
elite*gold: 0
Join Date: Oct 2008
Posts: 12
Received Thanks: 1
|
Lord xProdigy: How do you mean put it in or something else?  I deleted the files more than 10 times and tried to restore them, but still nothing.
Untouchable and Chernobyl: Its able to see everytime, i didn't change them.
I don't know guys, i have no idea...Is it works on mysql 2008? if yes i will try with that rogram. Anyway thank you for your helpings!
|
|
|
|
|
10/12/2012, 22:03
|
#8
|
elite*gold: 62
Join Date: Mar 2011
Posts: 602
Received Thanks: 2,955
|
Do they have .bak extension ?
|
|
|
|
|
10/12/2012, 22:24
|
#9
|
elite*gold: 130
Join Date: Mar 2008
Posts: 2,485
Received Thanks: 934
|
Do you know the name of the file? There's an application which indexes every file @&%!#@& fast, and you can find every file you want in 10 sec (unlike windows search, which takes 30 mins). I recommend to everyone to use it. 
|
|
|
|
|
10/12/2012, 22:46
|
#10
|
elite*gold: 0
Join Date: Oct 2008
Posts: 12
Received Thanks: 1
|
Yes, I know the files names, and i know where to place that files after you make new database. But it didn't appear when i make new database. These .bak files (SRO_VT_ACCOUNT.bak etc.). And there is .bak extensions to. I think the roblem is with sql wich doesnt make these bak files. Is there any way to change otion about restore database?
|
|
|
|
|
10/12/2012, 22:56
|
#11
|
elite*gold: 0
Join Date: Nov 2011
Posts: 89
Received Thanks: 81
|
might be funny question but are you sure that you're restoring database? because restoring a database and taking a back up look similar in SQL 2012,dunno how it looks like in the other SQL versions.
|
|
|
|
|
10/12/2012, 23:23
|
#12
|
elite*gold: 0
Join Date: Oct 2008
Posts: 12
Received Thanks: 1
|
Im using sql 2005. In there, if i make a new database, and give it a name then i click ok, it makes the .bak file which exactly i need for restore files. But it didn'aears for me. When im clickingmy new database and restre it, i can chose frome device. The bak files always in device C: under the windows folder. But now idk why (i didn't change the options, i use the default settings) they are nowhere. I loked after everything what you said, but nthing. If smebdy can, please upload these original .bak files to the net it would be easyer. I dnt want to reinstall my computer bec i dont have any ideas...
Okey the problem solved...Somebody sent me the files.
|
|
|
|
 |
Similar Threads
|
~--HELP--~>Restore Database Backup<--~
08/24/2012 - Metin2 Private Server - 0 Replies
Hi all,
I'm new here,and i don't know much about Database...
How can i load (Kay's331 2010) Datebank?
How can i add them into my database?
There are .frm,myd,myi files
Thanks, :)
|
restore database
12/02/2011 - Silkroad Online - 1 Replies
i want restore my database on sql server 2005.
I would like to transfer my actually db to an other one with user, collector, Item... to this new db.
is someone know how to do it?
|
error restore database
09/30/2011 - SRO Private Server - 6 Replies
http://img689.imageshack.us/img689/8815/wtflop.jpg
|
[TUTORIAL] Restore a SQL Server database
08/22/2011 - Dekaron Private Server - 4 Replies
# Date: June 20th, 2007
# Author: Steven Warren
# Category: Backup, Data Recovery
# Tags: Database, Microsoft SQL Server, Backup, Server
As a DBA, I have been in many situations where I had to move
databases to a new server due to old hardware, failed hardware, failed
drives, etc. You have two options you could use to carry out this task:
-SQL Server Management Studio (GUI)
-T-SQL (Command line)
|
Cant restore database
01/28/2010 - Dekaron Private Server - 10 Replies
Hm who is using sql 2008? I cant seem to restore the billing database,account database restores succesfull but billing does not work.
Any one stumped to this error to and how did you fix it? :mad:
|
All times are GMT +1. The time now is 12:12.
|
|
