These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

The SDE Has No Transaction Log
Author
Previous Topic Next Topic
Harry Potter
Bentusi Trading Company
#1 - 2013-04-21 18:40:25 UTC
I'm sure this is something really simple, but I'm just not seeing it. I am trying to restore the BAK in the static export to a SQL Server 2012 Express database. I cannot do so, because there is no log file. A google search indicates that one cannot restore a database without the log file.

I don't see any posts here indicating that anyone else had any difficulty with the export, so I'm assuming I've simply overlooked something. Does anyone have any ideas?

Thanks!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-04-21 20:48:48 UTC
Harry Potter wrote:
I'm sure this is something really simple, but I'm just not seeing it. I am trying to restore the BAK in the static export to a SQL Server 2012 Express database. I cannot do so, because there is no log file. A google search indicates that one cannot restore a database without the log file.

I don't see any posts here indicating that anyone else had any difficulty with the export, so I'm assuming I've simply overlooked something. Does anyone have any ideas?

Thanks!



I've restored it without any trouble.

http://phoenixdiaries.co.uk/eve-online-database-dump-and-sql-server-2012 may be of interest.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Harry Potter
Bentusi Trading Company
#3 - 2013-04-22 03:11:15 UTC
Oh, geez. Restore, then rename. I was trying to create the database, then restore on top of the empty database.

I knew it was something stupid.

Thanks!
Desmont McCallock
#4 - 2013-04-22 04:45:54 UTC
You don't even need to 'rename'. Just declare the name you want to use (To database) and then restore (from device).