hai expert....
which is the namespace for the Server Class ?
thanks..............
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manikavelu VelayuthamPosted Sep 28, 2010, 7:16 AM
Just go to this link and try to install any of the below 2 items and then try for it.
SQLServer2005_XMO_ia64.msi
SQLServer2005_XMO.msi
Soumya SurendranPosted Sep 28, 2010, 7:05 AM
Manikavelu VelayuthamPosted Sep 28, 2010, 7:04 AM
Soumya SurendranPosted Sep 28, 2010, 6:33 AM
Manikavelu VelayuthamPosted Sep 28, 2010, 5:38 AM
X64 Package (SQLServer2005_XMO_x64.msi) - 14675 KB
Microsoft reccomends it.
Soumya SurendranPosted Sep 28, 2010, 5:27 AM
Manikavelu VelayuthamPosted Sep 28, 2010, 4:56 AM
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Soumya SurendranPosted Sep 28, 2010, 4:42 AM
public void (string databaseName, string filePath)
{
try
{
Server localServer = new Server(); //local using windows athuentication
Backup backupMgr = new Backup();
backupMgr.Devices.AddDevice(filePath, DeviceType.File);
backupMgr.Database = databaseName;
backupMgr.Action = BackupActionType.Database;
backupMgr.SqlBackup(localServer);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.InnerException);
}
}
Manikavelu VelayuthamPosted Sep 28, 2010, 3:21 AM