Click here to Skip to main content
15,847,748 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC28-Apr-13 2:41
PrissySC28-Apr-13 2:41 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes28-Apr-13 13:49
professionalMycroft Holmes28-Apr-13 13:49 
AnswerAttached not seen over network still - will try ID values but .... Pin
PrissySC7-May-13 8:07
PrissySC7-May-13 8:07 
QuestionHow do I get the SSRS Report Mgr to work with a custom security extension? Pin
brandon schave23-Apr-13 7:31
brandon schave23-Apr-13 7:31 
QuestionTrouble restoring a mysql database Pin
savedlema22-Apr-13 8:21
savedlema22-Apr-13 8:21 
AnswerRe: Trouble restoring a mysql database Pin
Bernhard Hiller22-Apr-13 22:33
Bernhard Hiller22-Apr-13 22:33 
GeneralRe: Trouble restoring a mysql database Pin
savedlema2-May-13 0:44
savedlema2-May-13 0:44 
QuestionBack up database Error Pin
sara-setare20-Apr-13 22:37
sara-setare20-Apr-13 22:37 
Hi all,I have a problem with back up command!
I use this code but it doesnt work:
 string constr = @"DataSource=.\SQLEXPRESS;AttachDbFilename=C:\Users\EHSAN\Documents\Visual Studio 2010\Projects\hokm\hokm\App_Data\Database1.mdf;Integrated Security=True;User Instance=True;";
        System.Data.SqlClient.SqlConnection con = new  System.Data.SqlClient.SqlConnection ();
        con.ConnectionString = constr;
        con.Open();
System.Data.SqlClient.SqlCommand   comm=newSystem.Data.SqlClient.SqlCommand();
        comm.CommandText = @"backup database Database1 to disk ='c:\Users\EHSAN\Documents\Visual Studio 2010\Projects\hokm\hokm\DBbackup.bak' with init,stats=10";
        comm.Connection = con;
        comm.ExecuteNonQuery();
        con.Close();

and when I run it, I get this error:
Database 'Database1' does not exist. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
but I use the database1 and I connect it successfully!
what is the problem?
AnswerRe: Back up database Error Pin
Mycroft Holmes21-Apr-13 1:48
professionalMycroft Holmes21-Apr-13 1:48 
GeneralRe: Back up database Error Pin
sara-setare21-Apr-13 3:41
sara-setare21-Apr-13 3:41 
AnswerRe: Back up database Error Pin
Eddy Vluggen21-Apr-13 9:45
professionalEddy Vluggen21-Apr-13 9:45 
GeneralRe: Back up database Error Pin
sara-setare21-Apr-13 20:25
sara-setare21-Apr-13 20:25 
GeneralRe: Back up database Error Pin
Eddy Vluggen22-Apr-13 2:57
professionalEddy Vluggen22-Apr-13 2:57 
QuestionIs it a bad idea to keep a Database connection open Pin
Richard.Berry10020-Apr-13 0:42
Richard.Berry10020-Apr-13 0:42 
AnswerRe: Is it a bad idea to keep a Database connection open Pin
Eddy Vluggen20-Apr-13 0:47
professionalEddy Vluggen20-Apr-13 0:47 
GeneralRe: Is it a bad idea to keep a Database connection open Pin
Richard.Berry10022-Apr-13 9:23
Richard.Berry10022-Apr-13 9:23 
AnswerRe: Is it a bad idea to keep a Database connection open Pin
PIEBALDconsult20-Apr-13 6:26
mvePIEBALDconsult20-Apr-13 6:26 
AnswerRe: Is it a bad idea to keep a Database connection open Pin
GuyThiebaut20-Apr-13 21:38
professionalGuyThiebaut20-Apr-13 21:38 
AnswerRe: Is it a bad idea to keep a Database connection open Pin
jschell21-Apr-13 7:37
jschell21-Apr-13 7:37 
GeneralRe: Is it a bad idea to keep a Database connection open Pin
PIEBALDconsult22-Apr-13 7:38
mvePIEBALDconsult22-Apr-13 7:38 
GeneralRe: Is it a bad idea to keep a Database connection open Pin
jschell24-Apr-13 9:59
jschell24-Apr-13 9:59 
GeneralRe: Is it a bad idea to keep a Database connection open Pin
Richard.Berry10024-Apr-13 11:51
Richard.Berry10024-Apr-13 11:51 
AnswerRe: Is it a bad idea to keep a Database connection open Pin
Richard.Berry10022-Apr-13 9:17
Richard.Berry10022-Apr-13 9:17 
QuestionRecursively build a string Pin
Lash2019-Apr-13 13:26
Lash2019-Apr-13 13:26 
AnswerRe: Recursively build a string Pin
jschell21-Apr-13 7:38
jschell21-Apr-13 7:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.