C# and Linq: Generating SQL Backup/Restore From Code

Question

I'm working with a C# and Linq to SQL Winforms app and needed to integrate backup and restores through the program. I used SMO and got it working pretty smoothly. The issue, however, is that the app is deployed using ClickOnce, which I like very much - but since I had to include the dll's the download size jumped from 3mb => 15mb. I know they've only got to download it once, but it also sucks for me as Visual Studio 2010 seems to upload the dll's every time and that takes a while on AT&T broadband (eh).

So, anyone have any suggestion on how I can work out an effective backup/restore solution without using SMO objects?

Noel Kennedy · Accepted Answer · 2010-04-21 20:48:28Z

1

You can just fire plain ol'sql at the box via ado commands

answered Apr 21, 2010 at 20:48

Noel Kennedy

12.3k3 gold badges43 silver badges57 bronze badges

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

1 Comment

mdvaldosta Over a year ago

I like the idea of SPROC's, and should have thought of that. Thanks.

Robert Harvey · Accepted Answer · 2010-04-21 20:42:11Z

0

You can use stored procedures to do backup and restore in lieu of SMO. There are a number of samples available on the web, including this one.

answered Apr 21, 2010 at 20:42

Robert Harvey

182k48 gold badges349 silver badges516 bronze badges

Collectives™ on Stack Overflow

C# and Linq: Generating SQL Backup/Restore From Code

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related