Backup to laptop

You backup the database from SO Administrator or SO Manager. THis will ask you for a filename. Copy the File that is created over to your laptop. Then use SO Administrator on the Laptop to Create a new database using the copied file as the source. See the online help for details on backup and create....

Glenn Adams Tiber Creek C> How do i transfer the inventory and sales history onto a laptop? >

Or if you plan on doing this often, have a bat file that does the backup for you, and then a bat that does the "restore" for you on your laptop.

We run a .bat file each evening at closing that does the backup for us, zips the backup file giving about a 4:1 compression ratio (also copies to a couple of other networked computers in case of disk failure). Weekly I connect in from home and transfer the zip file, unzip it, then run a simple bat file to restore copy at home where I can run some reports.

John, Any chance you would share the exact details on how you do what you do. I've tried using the automatic backup described in the CustomerSource documents but can't get it to work. We do the manual backups daily and have Iomega backup transfer the backups to other computers every night, but I would love to get the exact details on having a scheduled full backup that happens without us having to think about it. Appreciate the help.

On the database server I have the following. We don't automatically kick of backup.bat. I have an icon on the desktop that the cashier doing the closing clicks as their last act of the day. You could just as easily us Windows Task Scheduler to kick it off each eveninng (remove the pause from the bat files if you do that). zip.exe is a publically available zip routine.

backup.bat: @echo off dir "C:\Program Files\Microsoft SQL Server\MSSQL\Data\posdb*" copy d:\pos_backup\posdb.zip d:\pos_backup\posdb-1.zip del d:\pos_backup\posdb.bak echo.

echo Generating SQL Backup osql -E -i d:\pos_backup\backup.sql echo. echo. echo. dir d:\pos_backup\posdb.bak echo.

echo. echo Compressing Backup File zip posdb *posdb.bak dir d:\pos_backup\posdb.* echo. del d:\pos_backup\posdb.bak echo.

echo. echo "Acquiring SYSTEM1 backup directory" net use z: \\system1\POSbackup

echo. echo Copying database xcopy d:\pos_backup\*.* z: /s /y echo. echo. echo "Releasing SYSTEM1 machine" net use z: /delete

echo. echo. echo "Acquiring SYSTEM2 backup directory" net use z: \\system2\drive_d

echo. echo Copying database xcopy d:\pos_backup\*.* z:\$userdata\pos_backup /s /y echo. echo. echo "Releasing SYSTEM2 machine" net use z: /delete

echo. echo. pause exit

backup.sql: backup database posdb to disk = 'd:\pos_backup\posdb.bak' go

Then on my home system I have

create_POSdb.bat: osql -E -i "D:\Transfer\posdb\create_POSdb.sql" pause exit

create_POSdb.sql: DROP DATABASE posdb RESTORE DATABASE posdb FROM DISK = "D:\Transfer\posdb\posdb.bak" WITH MOVE 'QSDB_Data' TO "c:\program files\Microsoft SQL Server\MSSQL\DATA\posdb_data.mdf", MOVE 'QSDB_log' TO "c:\program files\Microsoft SQL Server\MSSQL\DATA\posdb_log.ldf" GO

I hope this gives you all you need.

John, Excellent, thanks for sharing!

John, I noticed you have your backups set up with the .bak extension. I just want to pass along that Terrible Tom posted here last year that in his discussions with MS they told him that .bak was not a supported extension, that they support the .bck extension. I don't know if that matters to you, but I thought I'd pass it along. Craig

Yes you can back up and restore your mrms database from store admin

"christian" wrote: