Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.

How do I Backup my SQL Server 2005 Database using TSQL?

First connect to SQL Server Management Studio, either locally using Remote Desktop or externally.

You will need to update the database name and folder path in the script for the database you want to backup. In this example, the variables are ‘AdventureWorks’ and ‘C:\PathToBackupFolder\backupname.bak’.

USE AdventureWorks;
GO
BACKUP DATABASE AdventureWorks
TO DISK = ‘C:\PathToBackupFolder\AdventureWorks.Bak’
WITH FORMAT,
MEDIANAME = ‘C_SQLServerBackups’,
NAME = ‘Full Backup of AdventureWorks’;
GO

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Contact

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.