Where IT and IQ Collide

Support Center

Support Center » Knowledgebase » Backup and restore the database from a command prompt

 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options

 Backup and restore the database from a command prompt
Solution

You can use the following command to backup the TSC2 Help Desk database from a command prompt. You must run this on the computer running the SQL Server Desktop Engine.

OSQL /Q"BACKUP DATABASE TSC2 TO DISK='C:\TSC2.BAK' WITH INIT" /E

You can modify 'C:\TSC2.BAK' to backup the database to a different location.

You can use the following command to restore the TSC2 Help Desk from a command prompt. You must run this on the computer running the SQL Server Desktop Engine, the command expects the backup file (TSC2.BAK) to be in the root folder of the C: drive.

OSQL /Q"RESTORE DATABASE TSC2 FROM DISK='C:\TSC2.BAK' " /E

You can modify 'C:\TSC2.BAK' to restore the database from a different file or location.



Article Details
Article ID: 1
Created On: 19 Nov 2004 08:56 AM

 This answer was helpful  This answer was not helpful