Is it possible to create a DB snapshot using Smo entirely from C# .NET code
a related question: how can enumerate db snapshots smo?
thanks.
alexb
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
Post a Comment