How do I import my Veetro SQL Database backup on my own SQL Server 2005 Express edition?
Veetro 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\veetro backup.bak'
WITH MOVE 'VTRO_XXXXX_XXXXXXX_dat' TO 'c:\your\New_Database_File.mdf',
MOVE 'VTRO_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\veetro backup.bak
is the location you extracted your backup to.
VTRO_XXXXX_XXXXXXX
is Veetro's original database file name. For example, if your backup file is called "VTRO_070101062029_acmeinc-2007-01-01.BAK", you would enter "VTRO_070101062029_acmeinc_dat" and "VTRO_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.