MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
Scripting error but can connect remotely Options · View
Guest
#1 Posted : Friday, October 22, 2010 10:36:31 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
Great system thanks

I can connect to database remotely via SQL Server Manager Studio
It is a SQL Express 2005 on a PC with win XP and I am connecting from Windows SBS Server 2003

The program works well with the local SQL express on the server

I get the following error:

Database scripting failed: An error occured while getting databaseuser defiend types information. >> System.IndexOutOfRangeException: Precision
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at b.x.n(Stream A_0)

Hope you can help


Many thanks
ruslan
#2 Posted : Friday, October 22, 2010 10:48:43 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 437
It seems another permission issue when scripting engine had not enough permissions to get user defined types. That is why scripting is in permanent beta.
Guest
#3 Posted : Tuesday, October 26, 2010 10:03:46 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
ruslan wrote:
It seems another permission issue when scripting engine had not enough permissions to get user defined types. That is why scripting is in permanent beta.



I appreciate it is beta. Was hoping you could suggest a fix or workarround. perhaps i could add aditional permissions on the database? Any suggestions
Richard Mayer
#4 Posted : Monday, January 23, 2012 3:40:46 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
Did you ever find a way around this problem? I am trying to backup a Sage database and am finding this same errors you describe.
Alexander Omelchenko
#5 Posted : Thursday, August 18, 2016 3:29:17 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Please try to make your backup with or without SMO. You can find this option by clicking "Advanced" and then press "More backup options" link. In the opened window you can find "Use SMO for remote backup".
Also, you can find more information about remote backups at http://sqlbackupandftp.com/remote/
Forum Jump  
You cannot post new topics in this forum.
You cannot 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.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com