Backup a Database

STEP 1: Right click on database and then select Tasks then Back Up.

STEP 2: Click on Add button.

STEP 3: By clicking three dots (...) select you file location where you want to save the backup file.

STEP 4: Select location and type file name. Make sure to give file name with extension .bak.

STEP 5: Click OK.

STEP 6: Click OK.

STEP 7: Backup of database completed successfully.


SQL Script

BACKUP DATABASE [Hospital] 
TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup\Hospital_LogBackup_2023-05-24_11-48-21.bak' 
WITH NOFORMAT, NOINIT,  NAME = N'Hospital-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

Comments (0)