If you haven't installed SQL Management Studio and you need to backup or restore an Events2HVAC SQL database, here's the basic steps. SMS is the recommended tool for backup and restore.
Open the Command Prompt in Windows and enter the text below. This assumes that you are logged in as an Administrator and you are using Windows Authentication for database security.
For <servername> enter your SQL server\instance name.
BACKUP Events2HVAC
SQLCMD -E -S <servername> -Q "BACKUP DATABASE [Events2HVAC] TO DISK='C:\temp\events2hvac.bak'"
RESTORE Events2HVAC
SQLCMD -E -S <servername> -Q "RESTORE DATABASE [Events2HVAC] FROM DISK='C:\temp\events2hvac.bak'"
For full user guide on SQLCMD utility, see sqlcmd - Use the utility
0 Comments