| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Katana Seiko
Gallente
   |
Posted - 2008.11.09 22:15:00 -
[1]
Hi, I have a little problem with the last Data Export here.
I loaded SQL Server 2008 Express (because 2005 refuses to install on any 64bit system), from the Microsoft Server. I installed it, using standard settings through the bank.
After that was done, I loaded the Database Export.
The SQL file was integrated into my server just fine, but the BAK file - I have no idea how to integrate this data into my database. Did anyone do that before? If yes, please tell me how to do this.
---
"Multiple exclamation marks are a sure sign for a diseased mind." -Terry Pratchett |
Ambo
State Protectorate
|
Posted - 2008.11.10 08:02:00 -
[2]
I'm not quite sure what you're asking... but try this thread.
Incidentally, I'm running SQL server express 2005 on an XP 64bit system. I believe the only difference is that you also need .NET 2.0 x64
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Immersive
Immersive Technology Solutions
|
Posted - 2008.11.12 12:37:00 -
[3]
I am using SQL 2005 Express.
Grab the SQL Management Studio Express from Microsoft Downloads (it's Free, as in Beer)
Have a play with that. There's tools in there to restore databases from Backups (BAKs)
---
New to the API? GrabRaw XML
It's coming...
|
Alfred Spangler
Achmed Fleet
|
Posted - 2008.11.12 22:54:00 -
[4]
 Originally by: Katana Seiko
Hi, I have a little problem with the last Data Export here.
I loaded SQL Server 2008 Express (because 2005 refuses to install on any 64bit system), from the Microsoft Server. I installed it, using standard settings through the bank.
After that was done, I loaded the Database Export.
The SQL file was integrated into my server just fine, but the BAK file - I have no idea how to integrate this data into my database. Did anyone do that before? If yes, please tell me how to do this.
Out of memory... grab Sql Management Studio, like the poster above said, connect to your database engine, right click the server in the browser on the left, restore database or something, then use the wizard. You may have to create an empty DB first to be able to restor to it, and then right click the DB instead of the server, I can remember atm.
You may even be able to do that from VS 2008 (Express ?), as it has a database browser integrated.
Regards,A.S.
|
Sammie10
|
Posted - 2008.11.15 02:31:00 -
[5]
Katana,
If you are unsuccessful getting the data import to work in 2008 let me know and I will set it up and post instructions. |
The Power
Tenacious Danes
X13 Alliance
|
Posted - 2008.11.15 23:37:00 -
[6]
The data export is an backup :)
So you have to restore the .bak file.
Open your ms sql 2008 management studio .. connect to your server , run an 'New query'
past this in
RESTORE DATABASE [ebs_DATADUMP] /* This will be the name of the database after the restore */
FROM
DISK = N'D:\Downloads\DATADUMP20081007.bak' /* D:\Download is my path ... change it */
WITH FILE = 1
, MOVE N'ebs_DATADUMP' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\ebs_DATADUMP.mdf' /* Make sure this is the path where you installed you MS MSL */
, MOVE N'ebs_DATADUMP_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\ebs_DATADUMP.ldf'
, NOUNLOAD, STATS = 10
GO
Hope that helps 
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |