Geek Answers Handbook

SMO is not available in .NET 4.0? Or is there an easier way to back up a database from code

We upgraded our application to .NET 4.0 some time ago, and now you need to add the ability to backup SQL Server 2008 databases from the application. However, it seems that SMO is not available for .NET 4. Is there a workaround or a better way to back up the database (note that our backups must be initiated by the user on the website, so we cannot plan them) .

+5
source share
2 answers

Use BACKUP DATABASE ?

One,

+3

SMO .NET 4.0, .NET 2.0.

Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information., SQL Server SDK (SQL Server 2008 R2) , ​​ SQL Server, . 2005.

+2

More articles:


All Articles