"window server 2008 ကိုဘယ္လိုစသင္ရပါမလဲခင္ဗ်ာ"
Backup and Restore SQL Server databases programmatically with SMO
ကၽြန္ေတာ္ MSSQL database ကို Microsoft.SqlServer.Management.Smo ရဲ႕ Backup and Restore class ေတြကို သံုးၿပီး back up and restore လုပ္ပါတယ္.. ျဖစ္ေနတဲ႕ ျပသနာ က database server ကို တစ္ခါ access လုပ္ၿပီးသြားရင္ restore လုပ္လို႕ မရေတာ႕ဘူးခင္ဗ် back up ကေတာ႕ ရတယ္ ကၽြန္ေတာ႕ program က login အရင္ ၀င္ရပါတယ္ .. login ၀င္ၿပီးမွ restore လုပ္ရင္ Restore fail to server ဆိုတဲ႕ exception တက္ေနပါတယ္ ႀကံဳဖူးေသာ IT pros မ်ား ကူညီၾကပါဦးဗ်ာ
// Set the restore type to a database restore
rstDatabase.Action = RestoreActionType.Database;
// Set the database that we want to perform the restore on
rstDatabase.Database = cbo_DataBaseName.SelectedItem.ToString();
// Set the backup device to a file
BackupDeviceItem bkpDevice = new BackupDeviceItem(openBackupDialog.FileName, DeviceType.File);
// Set the backup device from which we want to restore, to a file
// Add the backup device to the restore type
rstDatabase.Devices.Add(bkpDevice);
// If the database already exists, replace it
rstDatabase.ReplaceDatabase = true;
// Perform the restore
rstDatabase.SqlRestore(srvSql);
// Set the restore type to a database restore
rstDatabase.Action = RestoreActionType.Database;
// Set the database that we want to perform the restore on
rstDatabase.Database = cbo_DataBaseName.SelectedItem.ToString();
// Set the backup device to a file
BackupDeviceItem bkpDevice = new BackupDeviceItem(openBackupDialog.FileName, DeviceType.File);
// Set the backup device from which we want to restore, to a file
// Add the backup device to the restore type
rstDatabase.Devices.Add(bkpDevice);
// If the database already exists, replace it
rstDatabase.ReplaceDatabase = true;
// Perform the restore
rstDatabase.SqlRestore(srvSql);
Views: 151
Replies to This Discussion
-
Permalink Reply by Ko-AKM on -
If you mention which sql server version and which language you are using will be better but see below links and may help.
http://www.codeproject.com/Articles/123441/SQL-Server-2008-Backup-a...
http://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-s...
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.managem...
-
Permalink Reply by Zar Ni Minn on -
ဟုတ္ကဲ႕ ေက်းဇူးပါ
ကၽြန္ေတာ္သံုးတာ SQL server 2005 ပါ language ကေတာ႕ C# ပါ
ျဖစ္ေနတဲ႕ျပသနာကေတာ႕ ထိုင္ခံုေပၚတက္ထိုင္ၿပီးမွ ထိုင္ခံုကို အသစ္လဲ ခ်င္တဲ႕ ျပသနာပါပဲ ခင္ဗ်ာ
-
Permalink Reply by htethsumyatyee on -
ဒီလိုမ်ိဳးၿဖစ္တာကအရင္backup ထုတ္တုန္းကနာမည္နဲ႕လမ္းေၾကာင္းအတိုင္ master file နဲ႕ log file ေတြက်န္ေနတာေၾကာင့္လို႕ထင္ပါတယ္။coding နဲ႕ေတာ့မလုပ္ဖူးပါဘူး။SQL Server 2005 database ထဲမွာဘဲတိုက္ရိုက္ backup & restore လုပ္ရင္ေတာ့ device ထဲမွာ ထည့္မယ့္backup file ကိုေရႊးၿပီး option ထဲကိုထပ္၀င္ၿပီးေတာ့ master file နဲ႕ log file ေတြရဲ႕လမ္းေၾကာင္းကို program file ထဲကေနၿပန္ေရႊးေပးရပါတယ္။အဲလိုၿပန္ေရႊးတဲ့ coding ပါထည့္ေရးၾကည့္ရင္ရႏိုင္မယ္ထင္ပါတယ္။အဲလို problem ထင္လို႕ပါ။သိသေလာက္ေလးေၿပာၿပတာပါ။အဲဒီ problem မဟုတ္တာလဲၿဖစ္ႏိုင္ပါတယ္။
Latest Activity
Aung Myo Htet replied to Ye Yan Aung's discussion online payment ကို ျမန္မာႏိုင္ငံမွာ အသံုးျပဳလို႔ရႏိုင္ပါမလား ... ?
Moe Sweet replied to Ye Yan Aung's discussion online payment ကို ျမန္မာႏိုင္ငံမွာ အသံုးျပဳလို႔ရႏိုင္ပါမလား ... ?
© 2013 Created by Ko Chit.
