SQL Server : backup database with T-SQL?

Question

I am looking for a way to backup a SQL Server database with T-SQL. I do no have root access to this server through the console, as my only access comes through SQL Server Management Studio.

Could someone please show me the SQL that I could use to export the raw SQL for my entire database?

JonH · Accepted Answer · 2012-03-05 21:23:57Z

4

BACKUP DATABASE @strDB TO DISK =@BackupFile WITH RETAINDAYS = 10, NAME = N'MyDataBase_DATA-Full Database Backup', STATS = 10

You must define @BackupFile and @strDB as the database name.

All of this is free in Books Online which you can find online.

answered Mar 5, 2012 at 21:23

JonH

33.2k13 gold badges93 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aaron Bertrand · Accepted Answer · 2012-03-05 21:43:12Z

2

If you only have access to the server through Management Studio, where do you expect it to stream your backup? Getting the T-SQL to work is one thing - getting SQL Server to be able to write the backup to a place where you can access it is quite another. You may want to look at Red-Gate's SQL Azure Backup:

http://www.red-gate.com/products/dba/sql-azure-backup/

answered Mar 5, 2012 at 21:43

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

Collectives™ on Stack Overflow

SQL Server : backup database with T-SQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related