check database online or offline

Question

0.00/5 (No votes)

See more:

hi i want to ask a question
how can check database online or offline if offline make online
and how can give my program permission to read and write file in my drive
like this code work with me in external driver like flash how can work in my internal hard disk

C#

string filename = textBox1.Text + "\\Issues" + DateTime.Now.ToShortDateString().Replace('/', '-')
 + " - " + DateTime.Now.ToLongTimeString().Replace(':', '-');
           string strquery = "Backup Database Issues to Disk='" + filename + ".bak'";
           cmd = new SqlCommand(strquery, cn);
           cn.Open();
           cmd.ExecuteNonQuery();
           cn.Close();

Posted 24-Sep-15 17:22pm

Member 11538085

Add a Solution

Comments

Afzaal Ahmad Zeeshan 25-Sep-15 0:38am

What do you mean by online or offline? Is there network included somewhere or do you mean to open the connection?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2015-09-24T20:23:00

As you are using SQL Server, you can take advantage of SMO (https://msdn.microsoft.com/en-us/library/ms162169.aspx[^]). It is far better than hit-miss.

Here is exactly what you have asked for (in VB, but quite simple to transscribe): https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database.status(v=sql.120).aspx[^]

Even better, you can use SMO to manage backups without T-SQL. See this article: SQL Server 2008 - Backup and Restore Databases using SMO[^]

Awadhendra Tripathi · Answer 2 · 2015-09-24T19:31:00

Solution 1

C#

if (SqlCon.State == ConnectionState.Open)
               {
                   //SqlCon.Close();
                   //SqlCon.Open();
               }

Posted 24-Sep-15 19:31pm

Awadhendra Tripathi

Comments

George Jonsson 25-Sep-15 2:15am

No variable declarations, no explanation.
Too little information to be a good answer.

Member 11538085 25-Sep-15 10:19am

i want check database SQL Server online or offline if offline make online