Is it possible to create a DB snapshot using Smo entirely from C# .NET code


is possible creat db snapshot using smo entirely c# .net code without resorting trans-sql , sp?

a related question: how can enumerate db snapshots smo?

thanks.
alexb

hello alex


there no support of creating databasesnapshots using smo instead of executing sql query. can iterate through databases , verify "isdatabasesnapshot" property know whether database snapshot or not.

 

server srv = new server(".");

 

string databasename = "test";

srv.connectioncontext.executenonquery(

string.format(@"create database {0} on ( name = {1}, filename = 'c:\program files\microsoft sql server\mssql.1\mssql\data\dbs.mdf' ) snapshot of {1}",

snapshotname,

databasename));

 

this.server.databases.refresh();

 

console.writeline("list of database snapshots:");

 

foreach (database db in srv.databases)

{

 

if(db.isdatabasesnapshot)

{

 

console.writeline(db.name);

}

}

thanks
sreekar



SQL Server  >  SQL Server SMO/DMO



Comments

Popular posts from this blog

Reindexing

Users List

List of charts