Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Incompatible database name (does not handle dashes properly) Options · View
Guest
#1 Posted : Thursday, November 18, 2010 11:41:40 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
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)
ruslan
#2 Posted : Thursday, November 18, 2010 12:12:06 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
You are right, it seems like a bug. We are rewriting the whole scripting engine, so this will be fixed when the new engine is released. Sorry, can't promise any dates.
Guest
#3 Posted : Thursday, November 18, 2010 12:17:12 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
Thanks Ruslan. Again, this is a killer product. Can't wait to use it.
Jeroen
#4 Posted : Wednesday, January 11, 2012 8:16:05 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
Hi,

Has this been tackled yet? I'm looking towards purchasing this product however I have also databases with dashes (and spaces) in their names.

Regards,

Jeroen
ruslan
#5 Posted : Wednesday, January 11, 2012 9:14:52 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
We have spent huge amount of time and money developing remote scripting process and it still has problems. So we call it "permanent Beta" and this feature is free. If it works for you - fine, if it doesn't - we have warned you. We do not plan on improving it in the next 6 months (cloud backup is the immediate priority), after that - we will see.
More details about remote sql backup.
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.