How to create a full database backup (SQL Server)?

Creating a full backup of your SQL Server database ensures your data is safely preserved before making any major changes, such as a migration. Here are two common ways to do it:

Using SQL Server Management Studio (SSMS)

1. Open SQL Server Management Studio and connect to your server.
2. In “Object Explorer“, expand Databases and right-click the database you want to back up.
3. Select “Tasks” > “Back Up…“
4. In the Back Up Database window, confirm the Backup type is set to “Full“.
5. Under “Destination“, choose where to save the backup file, or add a new path if needed.
6. Click “OK” to start the backup. Once complete, you’ll see a confirmation message.

Using a T-SQL query

1. Open a new query window in SSMS, connected to your server.
2. Run the following command, replacing the placeholders with your own details:

   sql
   
   BACKUP DATABASE your_database_name
   
   TO DISK = 'C:\Backup\your_database_name.bak'
   
   WITH FORMAT;

3. Wait for the query to complete, then check the specified folder to confirm the .bak file was created.

Once your backup is complete, store the .bak file somewhere secure, ideally separate from your live server, in case you need to restore it later.

If you have other questions or inquiries, please contact our Support Agents via live chat or email us at [email protected].