SQL BACKUP Query

Question

how can i backup data from a query with MSSQL. I think about something like this:

BACKUP DATABASE 'sourceDB' 
Select * from Table1 where Day = '12.01.2010';
TO DISK = 'F:\Program Files\Microsoft SQL Server\MSSQL\Backup\sourceDB.bak' WITH FORMAT

Thank you for your support!

Cheers

Stefan

DOK · Accepted Answer · 2010-11-30 13:34:21Z

4

If you have access to Management Studio, you can save query results to a file quite easily:

Open a query window. One way to do this is by right-clicking on the database name in the Object Explorer.
You might want to write the query and run it there first, to test that it is producing the desired results.
When you are ready to run the query and save it to file, on the menu choose Query, then Results To, and finally Results to File.
Now, when you run the query (F5), you will get a dialog box to indicate the filename and folder to save the data.

That's all there is to it.

answered Nov 30, 2010 at 13:34

DOK

32.8k8 gold badges64 silver badges93 bronze badges

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

Comments

Andomar · Accepted Answer · 2010-11-30 13:22:47Z

4

The backup command is used to backup entire databases into a proprietary format.

To store the result of a query in a file, check out the bcp utility. This allows you to run a query and store the result in a text file. One example:

bcp "SELECT * FROM Northwind.dbo.Customers" queryout "c:\text.txt" -c -T -x

answered Nov 30, 2010 at 13:22

Andomar

239k55 gold badges387 silver badges412 bronze badges

Collectives™ on Stack Overflow

SQL BACKUP Query

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