Quary for BACKUP and RESTORE in SQL Server -- Full Backups

# At a minimum you need to verify three things on this screen. First, that the correct database is selected. Second, that the backup type is set to FULL. Finally you need to choose the backup file name. On the Options tab you can specify whether SQL Server should replace or append the backup to the backup file. Keep in mind that the backup file is relative to where SQL Server is installed and not where you're running SSMS

# If you want to issue a backup statement yourself you can use SSMS to script it out for you. Click the Script button at the top of the dialog box and SSMS will generate this SQL statement for you:


BACKUP DATABASE [AdventureWorks] TO 
    DISK = N'\\nas\Backup\L40\SQL2005\AdventureWorks_backup_200702120215.bak'
    WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorks-Full Database Backup',
    SKIP, NOREWIND, NOUNLOAD,  STATS = 10