How to Create a Full Database Backup in SQL Server ?

Andrew Jackson ~ Modified: November 30th, 2015 ~ ~ 1 Minute Reading

This topic has 3 replies, 3 voices, and was last updated 9 years ago by Lincoln Burrows.

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts
November 30, 2015 at 12:26 pm #959 Score: 0

Andrew Jackson
Moderator

Karma: 1 pt

I want to create a full backup of my database, but i don’t know how to do this. How can i do this?

December 5, 2015 at 9:37 am #976 Score: 0
Stephen West
Moderator

Karma: 4 pts
Try this:
```
USE Databasename;
GO
BACKUP DATABASE Databasename
TO DISK = 'D:\SQLServerBackups\Databasename.Bak'
   WITH FORMAT,
      MEDIANAME = 'D_SQLServerBackups',
      NAME = 'Full Backup of Databasename';
GO
```
December 12, 2015 at 12:49 pm #998 Score: 0

Andrew Jackson
Moderator

Karma: 1 pt

Thanks Stephen West for the script, it helps me a lot, but I also want to know can i create a backup of the database from SQL Server Management Studio

December 15, 2015 at 12:37 pm #999 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

Creating backups using SQL Server Management Studio is pretty simple. Look at this blog for a description how to create a full database backup using SQL Server Management Studio and T-SQL: http://www.sqlserverlogexplorer.com/create-full-database-backup/
Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.