Error when restoring an SQL database

Hello,
Not sure if I've hit the right newsgroup, my apologies if not.
I work with a small software firm, whereby we predominantly develop Point of
Sale software, which can typically contain very large membership databases
(used at Universities and Sporting Venues).
I have received a backup from one of our clients, but am having issues
trying to restore it via Enterprise Manager. I am selecting a device, as I
have the .bak file sitting on my local hard drive, and selecting one device
only.
From the Restore database window, when I click on the Options tab, I get the
following error:
"Error 3205: Too many backup devices specified for backup or restore; only
64 are allowed. RESTORE FILELIST is terminating abnormally."
I can then click on OK and see the rest of the options screen, yet the
Logical file name and Move to physical file name options are left blank.
Even if I try to enter these fields manually and click on OK, I get a
similar error but with RESTORE DATABASE is terminating abnormally.
Is something going wrong with the way the client is backing up the data? I
don't know exactly what procedure they are using, but I'm assuming they are
just using the backup function from with Enterprise Manager.
Could something be going wrong with the way they are sending me the
database? I have received to copies, one as a spanned Zip file and one as a
spanned Winrar file, but I have the same issue with both copies.
Any advise would be appreciated.
Adrian Robertson
CENTAMAN SystemsAdrian,
from your description it seems like the fileheader of the backup file
is corrupt. The restore process can't read the information about the
logical name and the physical path. You can try to run RESTORE
HEADERONLY but I suspest that you get the same error.
Markus|||Hi Marcus
I tried the "View Contents" option and got a similar error, but I can't see
any option to restore headers only (though I agree, I think I'll have the
same issue).
Should I see this in the same area somewhere?
I'm using Microsoft SQL Enterprise Manager version 8.0 if that's any help.
In the event that the header record is corrupt as you suggest, is there
anything I can suggest the client do to improve their backup procedure, or
is this likely to be an issue in the underlying database?
Adrian
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1144220472.886147.50950@.u72g2000cwu.googlegroups.com...
> Adrian,
> from your description it seems like the fileheader of the backup file
> is corrupt. The restore process can't read the information about the
> logical name and the physical path. You can try to run RESTORE
> HEADERONLY but I suspest that you get the same error.
> Markus
>|||Hi,
I think it might be a version compatibility issue. The client is running SQL
Server 2005 9.00.1399
Typically I am running SQL Server 2000
I have a developers edition of SQL Server 2005 9.00.1116, but even when
using this I am unable to restore a backup created in 9.00.1399.
Are there any options in SQL Server 2005 that allows you to take a backup
that will be backward compatible?
Adrian
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1144220472.886147.50950@.u72g2000cwu.googlegroups.com...
> Adrian,
> from your description it seems like the fileheader of the backup file
> is corrupt. The restore process can't read the information about the
> logical name and the physical path. You can try to run RESTORE
> HEADERONLY but I suspest that you get the same error.
> Markus
>sql

Error when I try to add Output Column in in Data Conversion

Here is what I get. Is this an install problem or is this how this software works?

===================================

Error at Data Flow Task [Data Conversion [720]]: An output cannot be added to the outputs collection.

(Microsoft Visual Studio)

===================================

Exception from HRESULT: 0xC020800F (Microsoft.SqlServer.DTSPipelineWrap)

Program Location:

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.InsertOutput(DTSInsertPlacement eInsertPlacement, Int32 lOutputID)
at Microsoft.DataTransformationServices.Design.Controls.ComponentMetaDataTreeView.AddOutput()

What did you do to cause the error?

-Jamie

|||When in a package I added a data flow object then drilled into to add data source etc.

One of the items in the tool bar is Data Conversion. I whent to Advance edit on DataConversion on the last tab there was a button to "Add Output"

The result was the error above|||

PeterFreeb wrote:

When in a package I added a data flow object then drilled into to add data source etc.

One of the items in the tool bar is Data Conversion. I whent to Advance edit on DataConversion on the last tab there was a button to "Add Output"

The result was the error above

This is completely correct. it is not possible to add an output to the Data Conversion component. It only has one output and that exists as soon as you drag it onto the design surface.

What exactly are you attempting to do?

-Jamie

|||I have a unicode field in SQL and am trying to go non unicode or VARCHAR2 in Oracle.|||

PeterFreeb wrote:

I have a unicode field in SQL and am trying to go non unicode or VARCHAR2 in Oracle.

OK, well you have no need to go anywhere near the Advanced Editor. Just open the component up by double-clicking on it and add your data conversion in the GUI.

-Jamie

|||OK thanks I have a more involved question for Jamie or whoever knows...

I need to do an update or insert - I could do this easyly in SQL am not sure how to accomplish this in SSIS.

1. Check if the record is in the destination
2. If true -> Update
3. Else ->Insert|||

PeterFreeb wrote:

OK thanks I have a more involved question for Jamie or whoever knows...

I need to do an update or insert - I could do this easyly in SQL am not sure how to accomplish this in SSIS.

1. Check if the record is in the destination
2. If true -> Update
3. Else ->Insert

All documented here Peter:

Checking if a row exists and if it does, has it changed?
(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

-Jamie

Error selecting text from a SQL database

Hello,
I have an application that used an access database and I am currently
migrating to SQL Server. The software is designed to use Odbc object
found in the .Net framework version 1.1. I have a simple select
statement that is driving me nuts. It works fine with the Access
databases but dies under SQL Server.
The statement is:
SELECT
settingValue
FROM
tblSettings
WHERE ( owner=@.owner and setting=@.setting )
settingValue is an ntext field and owner and setting are varchar fields.
When I try to execute the query I get an error:
ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
ntext, and image data types cannot be compared or sorted, except when
using IS NULL, or LIKE operator.
There are no indexes on any of the fields so I cannot figure out what
the problem is.
Mageos
Try this to see if you still get an error:
SELECT
owner,
setting,
settingValue
FROM
tblSettings
WHERE owner = @.owner
and setting=@.setting
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mageos" <matt.dot.osborne@.cox.dot.com> wrote in message
news:vbGyd.2281$wZ2.581@.newssvr13.news.prodigy.com ...
> Hello,
> I have an application that used an access database and I am currently
> migrating to SQL Server. The software is designed to use Odbc object
> found in the .Net framework version 1.1. I have a simple select
> statement that is driving me nuts. It works fine with the Access
> databases but dies under SQL Server.
> The statement is:
> SELECT
> settingValue
> FROM
> tblSettings
> WHERE ( owner=@.owner and setting=@.setting )
> settingValue is an ntext field and owner and setting are varchar fields.
> When I try to execute the query I get an error:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
> ntext, and image data types cannot be compared or sorted, except when
> using IS NULL, or LIKE operator.
> There are no indexes on any of the fields so I cannot figure out what
> the problem is.
> Mageos
|||> settingValue is an ntext field and owner and setting are varchar fields.
> When I try to execute the query I get an error:
> ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]The text,
> ntext, and image data types cannot be compared or sorted, except when
> using IS NULL, or LIKE operator.
The error tells you exactly where the problem is. You are trying to do a
compare on an ntext field. Double check your create table statement. I think
you will find that either owner or setting is not of the datatype you
expected. What method of creating the tables in SQL did you use. I find that
often when I let SQL help me out converting data from an outside source, it
comes up with insane assumptions about what the datatype needs to be.
I tried reproducing the error with the script below and it works fine for
me.
create table test(
settingvalue ntext,
owner varchar(5),
setting varchar(5)
)
insert test (settingvalue, owner, setting)
values ('jgdfkjgiugsv8ohyohfef mne hevbe vmnerv', '1', '2')
declare @.owner varchar(5)
declare @.setting varchar(5)
set @.owner = '1'
set @.setting ='2'
select * from test where owner = @.owner and setting = @.setting