|
Hi,
I'm gonna get a SQL backup with below method :
void BackupDatabase(string sConnect, string dbName, string backUpPath)
{
using (SqlConnection cnn = new SqlConnection(sConnect))
{
cnn.Open();
dbName = cnn.Database.ToString();
ServerConnection sc = new ServerConnection(cnn);
Server sv = new Server(sc);
BackupDeviceItem bdi = new BackupDeviceItem(backUpPath, DeviceType.File);
Microsoft.SqlServer.Management.Smo.Backup bk = new Backup();
bk.PercentComplete += new PercentCompleteEventHandler(percentComplete);
bk.Devices.Add(bdi);
bk.Action = BackupActionType.Database;
bk.PercentCompleteNotification = 1;
bk.BackupSetDescription = dbName;
bk.BackupSetName = dbName;
bk.Database = dbName;
bk.LogTruncation = BackupTruncateLogType.Truncate;
bk.FormatMedia = false;
bk.Initialize = true;
bk.Checksum = true;
bk.ContinueAfterError = true;
bk.Incremental = false;
bk.SqlBackup(sv);
}
}
But an exception has occurred :
Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server '\\.\pipe\3F103E6E-3FD4-47\tsql\query'
additional info about the Exception:
{Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server '\\.\pipe\3F103E6E-3FD4-47\tsql\query'. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
=== Pre-bind state information ===
LOG: User = MDS-PC\MDS
LOG: DisplayName = Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
(Fully-specified)
LOG: Appbase = file:LOG: Initial PrivatePath = NULL
Calling assembly : Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91.
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: D:\My Works\C#\Win Form\Reza Restaurant\RezaRestaurant\bin\Release\RezaRestaurant.vshost.exe.Config
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\config\machine.config.
LOG: Post-policy reference: Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
LOG: Attempting download of new URL file:LOG: Attempting download of new URL file:LOG: Attempting download of new URL file:LOG: Attempting download of new URL file:
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
at RezaRestaurant.Form_تنظیمات_نرم_افزار.BackupDatabase(String sConnect, String dbName, String backUpPath) in D:\My Works\C#\Win Form\Reza Restaurant\RezaRestaurant\Forms\تنظیمات_نرم_افزار.cs:line 260
at RezaRestaurant.Form_تنظیمات_نرم_افزار.button_تهیه_نسخه_پشتیبان_Click(Object sender, EventArgs e) in D:\My Works\C#\Win Form\Reza Restaurant\RezaRestaurant\Forms\تنظیمات_نرم_افزار.cs:line 177}
Would you please guide me ?
Thanks.
|
|
|
|
|
Check if you have the package installed in the computer. In case it is not, you will need to install it. You can get the package from MSDN.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Do you mean here[^] ? if so, I installed
Microsoft SQL Server 2008 Management Objects
X64 Package (SharedManagementObjects.msi) - 3895 KB
But I receive the exception again.
|
|
|
|
|
SQLServer2005_XMO.msi does that for SQL Server 2005 32-bit. I am not sure about SQL 2008. Probably you can search for similar file for SQL 2008. Also, once you install the package, check for the dll at the following path:
c:\Program Files\Microsoft SQL Server\100\SDK\Assemblies
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
|
Check the SQL version. In the previous post of yours, you gave link to file for SQL 2008 and now for SQL 2005. Just make sure you have correct files.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Actually I have been installed VS2008 and as I know it installed SQLExpress2008,
d@nish wrote: Just make sure you have correct files.
I installed it and the exception haven't occurred anymore, now the method works well.
|
|
|
|
|
I want to create a new windows service which supposed to send mails every hour.
I know how to send an email message, but I don't know how I can make sure that it happens every hour (what code I should write, where I should place it). Someone can help me?
|
|
|
|
|
You can make use of System.Timers.Timer. Enable it in the OnStart method of your service and set its interval as 1 hour. Then, handle its Elapsed event and perform email sending there.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
I voted this as a good answer even though you recommended the use of a timer object instead of using a thread of some kind. 
Timer events are the lowest priority message in Windows, and on a busy system, the message is not guaranteed to be sent, much less retrieved.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
That can be a good thing.
|
|
|
|
|
Thanks.
I am not sure how I would employ threads for this. (Is it suspend/start kind of thing that you are referring).
John Simmons / outlaw programmer wrote: Timer events are the lowest priority message in Windows, and on a busy system, the message is not guaranteed to be sent, much less retrieved.
IMHO when you are sending mails, you should not be expected to make it happen instantly. Reason being even though your code works perfect, there is always a chance of email server not being upright (unless you have your own and you guarantee it will always work). So a couple of seconds or even a minute or so should not trouble. I also believe that threads can actually mess up the whole application if not used sensibly and accurately. And IMHO when application goes live, only then one can check how well he has handled threads (just an opinion).
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
d@nish wrote: I am not sure how I would employ threads for this. (Is it suspend/start kind of thing that you are referring).
Just use a BackgroundWorker that sits and spins. It can't wait more than 4 seconds before cycling (in a loop) because task manager will shut a windows service down that looks like its not active. It can be canceled, so there's no problem with running it in a service. I abhor the use of timers, and I view them with the same disdain I reserve for goto statements.
d@nish wrote: IMHO when you are sending mails, you should not be expected to make it happen instantly. Reason being even though your code works perfect, there is always a chance of email server not being upright (unless you have your own and you guarantee it will always work). So a couple of seconds or even a minute or so should not trouble. I also believe that threads can actually mess up the whole application if not used sensibly and accurately. And IMHO when application goes live, only then one can check how well he has handled threads (just an opinion).
I don't understand your concern. Once an hour you send an email. Period. Whether or not the SMTP server is available and whether or not you even need to care depends on the environment. If the server isn't on your local domain, there's nothing you can do except send the email and hope for the best. It has nothing to do with the threading model you chose to implement the cycle.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
John Simmons / outlaw programmer wrote: Just use a BackgroundWorker that sits and spins.
I don't believe a BackgroundWorker can be used in a Windows service. It's designed to be used in combination with a UI thread.
/ravi
|
|
|
|
|
Yes, it most certainly can be used in a Windows Service.
Technically, it's designed to send notifications concerning its status, regardless of its environment.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Once an hour is rather infrequent; a Windows Scheduled Task might suffice.
|
|
|
|
|
You don't need to be a programmer to do this though - it's a matter of job security.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
After performing operations on mutiple images at the same time(batch image processing) I want to save the images in the same format as the original one.How can I achieve this Can someone pls help.
|
|
|
|
|
Have you considered Image.Save[^]?
All those who believe in psycho kinesis, raise my hand.
|
|
|
|
|
Hi,
Has anyone experienced issues using functions such as SetWindowPos() when moving maximized remote desktop windows over extended desktops.
When I maximize the remote desktop to one of my screens and move the remote desktop to another screen using the c# MoveWindow() function the Remote Desktop yellow title tool bar gets left behind.
What I want to do is take the remote desktop out of full screen mode and run it in a restored state on another screen.
Is there an alternative as SetWindowPos only seems to handle regular windows.
It also seems to not handle multiple screens very well as when I use the functionality to maximize a screen the edges take up 4 pixel columns from point -4 to 0 and from point 1024 - 1028, where I have to manually adjust.
Hopefully I’m just using the wrong functions to position windows.
Functions uses: GetWindowRect, SetWindowPos, MoveWindow, GetWindowPlacement.
As per the following using parameters:
SW_HIDE = 0;
SW_SHOWNORMAL = 1;
SW_SHOWMINIMIZED = 2;
SW_SHOWMAXIMIZED = 3;
SW_SHOWNOACTIVATE = 4;
SW_RESTORE = 9;
SW_SHOWDEFAULT = 10;
For Min, Max and Normal:
WINDOWPLACEMENT param = new DisplayManager.WINDOWPLACEMENT();
GetWindowPlacement(referenceHandle, ref param);
param.showCmd = SW_SHOWMINIMIZED;
SetWindowPlacement(referenceHandle, ref param);
To bring a window to top:
SetWindowPos(Handle, HWND_TOPMOST, xPos, yPos, width, height, TOPMOST_FLAGS);
To move a window to a specific location:
MoveWindow((IntPtr)positionHandle, (offset + xPos), yPos, width, height, true);
Getting the position of a window:
GetWindowRect((IntPtr)positionHandle, ref activeAreaApp);
Patrick.
|
|
|
|
|
It appears as if the remote desktop title bar only displays on the primary monitor.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
In my situation the remote desktop title bar is sticking to the screen which it was maximised on. I'm driving four screens including the primary where I have remote desktops on each screen. When I minimise each remote desktop each screen keeps the associated toolbar at the top of the screen.
It looks like a maximised remote desktop is a different type of window mode when compared with an application like word. Maybe it's running a type of console / kiosk mode window which behaves differently.
|
|
|
|
|
namespace example
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void addEmployeeNumberToolStripMenuItem_Click(object sender, EventArgs e)
{
//this.comboBox1.Items.Add(textBox1.Text);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
Hello, I have a form with one combobox on it- and menu item: addEmployeeNumber.
is there a way to click employeeNumber toolstrip menu and have a text box display and then once filled with data -it can be added to combobox- or another way- my code this.comboBox1. items. add ( textbox1.text); is not working the right way.
|
|
|
|
|
Why don't you show a new form to capture the data you require and raise an event with custom args to send the data back to the host form where you can update the combo?
I gave an example here[^] the other day.
Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
