Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Error retirieving meta data Options · View
Previous Topic · Next Topic
Guest
#1 Posted : Wednesday, August 11, 2010 4:46:48 AM Quote
Rank: Guest

Groups:

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

Following exception is thrown when i try to remote backup on of our databases at our provider. Connection via Management Studio works fine. Any Ideas?

Database scripting failed: An error occured while getting tables information. >> System.ApplicationException: An error occured while getting tables information. ---> System.Data.SqlClient.SqlException: Falsche Syntax in der Nähe von '0100494'.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
bei System.Data.SqlClient.SqlDataReader.get_MetaData()
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
bei b.p.c(String A_0)
--- Ende der internen Ausnahmestapelüberwachung ---
bei b.p.c(String A_0)
bei b.x.a(Stream A_0, List`1& A_1)
Back to top
  |
ruslan
#2 Posted : Wednesday, August 11, 2010 6:37:19 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
If I am not mistaken, you are able to connect to the remote database both with studio and SqlBackupAndFtp, right? Most probably even though you are able to connect, you still need to have additional permissions to create a script. Let me get back to you on this with greater detail a bit later.
Back to top
 Report Abusive | Report SPAM
Guest
#3 Posted : Wednesday, August 11, 2010 7:58:20 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
Yes to all of your suggestions! ;)

And thanx for your help!
Back to top
  |
ruslan
#4 Posted : Thursday, August 12, 2010 9:23:40 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
Sorry, I don't have a better answer. If you are able to connect and view the tables, you should be able to create a script. There's a reason we don't support scripting portion - it is tricky.
Back to top
 Report Abusive | Report SPAM
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.