Script to restore SQL Server database

A lot of people know how to restore an SQL Server database using the SQL Server Management Studio. Sometime it will not work if the database is in use. You have to close all active connections or even to take database offline and then online again.

It is much easier to restore the database via the attached script. Just unzip the file to a folder called C:\RestoreDB and copy the backup file to the same folder. Then edit RestoreDB.bat file and update it with the appropriate information – server name, user name, password, backup name, etc.

The last step is to run RestoreDB.bat – you can double-click it in Windows explorer or can oped a DOS prompt change the folder to C:\RestoreDB and run the script by typing its name and pressing “Enter” key.

RestoreDB_Script

VMware ESXi

Step 1. Connect to ESXi console and press the Alt+F1 key combination.

Step 2. Type unsupported and then press . Note that nothing will appear on the screen whilst you type this.

Step 3. When prompted enter in the Root password and press.

Step 4. You will now be presented with a prompt on the console. From this prompt type vi /etc/inetd.conf

Step 5. vi (the file editor) has now opened the inetd.conf file. Using the direction arrows scroll through the lines until you reach the line that has #ssh and remove the hash (ie: #). This is effectively un-commenting this line so that the ssh service can be started.

Step 6. Now that you have made this minor file you want to save this change and exit out of the editor (vi). To do this press the ESC key (to put vi back into Command Mode) and then type :wq *Note: If you want to exit without saving any changes to the file then just press the ESC key (Command Mode) and then type :q!.

Step 7. With the SSH service now un-commented from this file we want to restart the