How do I import my WORKetc SQL Database backup on my own SQL Server 2005 Express edition?
WORKetc allows you to backup your SQL Server database at any time. The file is
provided in a .zip archive and contains a single *.BAK file, which contains your
SQL data.
After downloading your backup and extracting your *.BAK file,
open SQL Server Management Studio, connect to your local SQL server and paste in
this Query:
RESTORE DATABASE [NewDatabaseName]
FROM DISK = 'c:\your\worketc backup.bak'
WITH MOVE 'WETC_XXXXX_XXXXXXX_dat' TO 'c:\your\New_Database_File.mdf',
MOVE 'WETC_XXXXXX_XXXXXXXX_log' TO 'c:\your\New_Database_File.ldf',
REPLACE
Where
...
NewDatabaseName
is the name of
the database you want to restore your database as.
c:\your\worketc backup.bak
is the location you extracted your backup
to.
WETC_XXXXX_XXXXXXX
is WORKetc's
original database file name. For example, if your backup file is called
"WETC_070101062029_acmeinc-2007-01-01.BAK", you would enter "WETC_070101062029_acmeinc_dat" and
"WETC_070101062029_acmeinc_log"
respectively.
c:\your\New_Database_File.mdf/.ldfis
the location where you want to keep your new database files. This is often under
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" by default.