Using SMO in C# to backup SQL Server database

Question

I'm developing a simple utility which is going to create a *.bak file from a SQL Server database.

If database has a quite small size, less than 50 Mb, then there is no problem, it's working well. But potentially I'm going to work with big databases of 2-3Gb data size.

Since it's impossible (I guess) to keep such a big data in the memory to create *.bak file, would my utility still work in this case?

How does the SQL Server Management Studio backup of such large databases work? The backup process is streaming the data to disk - chunk by chunk. It's not keeping the whole database in memory and then dumping it to disk.... — marc_s
– marc_s, Commented Oct 30, 2012 at 17:50
Note: Default command timeout is set to 10 minutes, you can set property called StatementTimeout in the ServerConnection class. Setting this to zero disables the timeout. — Luke Hutton
– Luke Hutton, Commented Oct 30, 2012 at 18:03

Tarzan · Accepted Answer · 2012-10-30 19:49:35Z

2

Yes, your utility will still work with databases that are 2 -3 Gb in size.

answered Oct 30, 2012 at 19:49

Tarzan

4,5789 gold badges56 silver badges77 bronze badges

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

Comments

Ehsan Mirsaeedi · Accepted Answer · 2012-11-03 22:47:43Z

1

Yes! behind the scene Sql Server Management Studio uses smo models for it`s tasks such as backup and restoring. it can handle backups so also you can do your job using smo functionality.

answered Nov 3, 2012 at 22:47

Ehsan Mirsaeedi

7,7123 gold badges47 silver badges51 bronze badges

Collectives™ on Stack Overflow

Using SMO in C# to backup SQL Server database

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