CODEWITHSUNDEEP
c#sql-serversql-server-2008-r2smo
Alan Coromano
Alan Coromano

Reputation: 26008

Using SMO in C# to backup SQL Server database

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?

Upvotes: 0

Views: 616

Answers (2)

Ehsan Mirsaeedi
Ehsan Mirsaeedi

Reputation: 7592

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.

Upvotes: 1

Tarzan
Tarzan

Reputation: 4538

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

Upvotes: 2

Related Questions