command for checking windows version & server serial number

Command for checking windows version:

systeminfo | findstr /B /C:"OS Name" /C:"OS Version"



Command for checking server serial number:

wmic bios get serialnumber

MS SQL 2008 Manually Backup & Restore

1. Open Microsoft SQL Server Management Studio
2. Select database_name, right click, select Tasks --> Backup





3.Select backup type and Destination







4. Restore Flow