I am receiving the following issue when trying to back a database up to a networked drive. The issue seems to be stemming from the fact that one part in the script generation does not handle dashes properly. My database name that I am trying to back up from is [encana-matt], however, the error seems to be coming from the fact that it is trying to use [encana] (the -matt looks like it is being stripped off.
Without renaming all my databases, will; there be a solution to this anytime soon? Thanks, and I love your product, for what we are doing I think it will fit the bill perfectly.
Database scripting failed: An error occured while getting tables information. >> System.ApplicationException: An error occured while getting tables information. ---> System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'encana'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at b.p.c(String A_0)
--- End of inner exception stack trace ---
at b.p.c(String A_0)
at b.x.a(Stream A_0, List`1& A_1)