Home » Reply » Reply To: How to Create a Full Database Backup in SQL Server ?

Reply To: How to Create a Full Database Backup in SQL Server ?

Stephen West ~ Modified: December 5th, 2015 ~ ~ 1 Minute Reading

Home Forums How to Create a Full Database Backup in SQL Server ? Reply To: How to Create a Full Database Backup in SQL Server ?

#976 Score: 0
Stephen West
Moderator
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