Sequoia database reload Howto

From: Edward Cherlin <echerlin_at_gmail_dot_com>
Date: Tue Oct 20 2009 - 22:39:03 CDT

From Slashdot:

How to restore the .bak file using Microsoft SQL.. (Score:3, Informative)
by Anonymous Coward on 2009-10-20 18:19 (#29817689)

How to restore the .bak file using Microsoft SQL Server Express 2008:

Step 1. Go download SQL Server Express 2008 (This is trivial, left up
to the reader. You might have to go to a microsoft webpage) and
install.

Step 2. Go download SQL Tools for SQL Server (Trivial) and install.

Step 3. Go download the .bak.zip file from the above wiki. Save it to
'C:\foofoo\'. Unzip the .bak file within it to 'C:\foofoo\'. You
should now have: 'C:\foofoo\RIV_20081104_Canvass_Final_dbset_E.bak'

Step 4. Start up SQL Server Express

Step 5. Open SQL Management Studio and connect to your local
SQLEXPRESS instance.

Step 6. Click on the top most node in (Should be your machine's
name\SQLEXPRESS). Click "New Query".

Step 7. Run the following query:

RESTORE DATABASE RIV_20081104_E FROM
disk='C:\foofoo\RIV_20081104_Canvass_Final_dbset_E.bak'
WITH MOVE 'RIV_20081104_Esys' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\RIV_20081104_Esys.mdf',
          MOVE 'RIV_20081104_Edat' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\RIV_20081104_Edat.mdf',
          MOVE 'RIV_20081104_Elog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\RIV_20081104_Elog.ldf',
          REPLACE
go

Step 8. Wait.

Step 9. This should create a database called RIV_20081104_E.

Have fun.

-- 
Edward Mokurai (默雷/धर्ममेघशब्दगर्ज/دھرممیگھشبدگر ج) Cherlin
Silent Thunder is my name, and Children are my nation.
The Cosmos is my dwelling place, the Truth my destination.
http://www.earthtreasury.org/
_______________________________________________
OVC-discuss mailing list
OVC-discuss@listman.sonic.net
http://lists.sonic.net/mailman/listinfo/ovc-discuss
By sending email to the OVC-discuss  list, you thereby agree to release the content of your posts to the Public Domain--with the exception of copyrighted material quoted according to fair use, including publicly archiving at  http://gnosis.python-hosting.com/voting-project/
Received on Sat Oct 31 23:17:04 2009

This archive was generated by hypermail 2.1.8 : Sat Oct 31 2009 - 23:17:10 CDT