T-SQL to Perform Backups

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

thasteve SSCrazy Points: 2707 More actions · Answer 1

Skandalis Hall of Fame Points: 3517 More actions · Answer 2

- In Management Studio, right click on the database.

- Select tasks -> Backup...

- There's a button called 'Script' at the top of the next screen that will create a script.

To fully understand the script, search 'Backup' in Books Online (Content type = T-SQL)

Hans Lindgren SSChampion Points: 10496 More actions · Answer 3

And to summarize the topic on BOL:

BACKUP DATABASE NorthWind

TO DISK='C:\NorthWind.20080515.SQLBackup.Full.bak'

Simon Facer SSCertifiable Points: 5427 More actions · Answer 4

Check out my script on this site - http://www.sqlservercentral.com/scripts/Backup/62095/. And if you run the sp_DatabaseBackup with @Debug=1 setting, it will show you the backup commands it executes.

Ola Hallengren Hall of Fame Points: 3970 More actions · Answer 5

I have a backup stored procedure as well, that you are welcome to use.

EXECUTE dbo.DatabaseBackup @databases = 'USER_DATABASES', @Directory = 'C:\Backup', @BackupType = 'FULL', @verify = 'Y', @CleanupTime = 24

Here it is doing a full backup of all user databases, verifies the backups and on success deletes all files that are older than 24 hours.

Ola Hallengren

scott.data Newbie Points: 3 More actions · Answer 6

I've had good luck with the sqlmaint utility for SQL 2005 Express:

You can find it here.