Error restoring a database

Please that anybody help me.

I have a phisical device called 'respaldo.bak' inside this file there are three backups of three different databases, The first one is database called 'innovasoft' the second one is 'modelo_de_datos' and the last one is 'Inversiones'.

If I perform a restore of the first one there is no problem, but, when i try to restore the second o third database i get the following error:

TITLE: Microsoft SQL Server Management Studio

Restore failed for Server 'COMPUTO'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

El archivo lógico 'INNOVASOFT_Datos' no es parte de la base de datos 'PROBANDO'. Use RESTORE FILELISTONLY para enumerar los nombres de los archivos lógicos.
Fin anómalo de RESTORE DATABASE. (Microsoft SQL Server, Error: 3234)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3234&LinkId=20476

BUTTONS:

OK

I have to say that i want to restore the database with a different name that's why in the error says 'PROBANDO' , i'm really concern about this problem because it means that i have no backups for my data. I used to use this procedure on sql server 2000 every single day without problems, but on sql server 2005 it doesn't work properly.

Please help me.

Thanks in advance.

Make sure you restore with a file destination plus move.

Here is a quick demo showing how it all works.

Code Snippet

--create 3 test dbs
use master
go
create database db1
go
create database db2
go
create database db3
go

--add dummy data to db2
exec db2..sp_executesql N'select db_name() [db] into db'
go

--backup dbs to disk
backup database db1
to disk='c:\dbs.bak'
with init
go
backup database db2
to disk='c:\dbs.bak'
go
backup database db3
to disk='c:\dbs.bak'
go

--restore db2 to new db
restore database db2_2
from disk='c:\dbs.bak'
with file=2,replace,
move 'db2' to 'c:\db2_2.mdf',
move 'db2_log' to 'c:\db2_2.ldf'
go

--check to make sure we actually restore db2
exec db2_2..sp_executesql N'select * from db'
go

--clean up
drop database db2_2, db3, db2, db1
go

|||

Hi, sorry that i answer until today. Well this was what i done

backup database modelo_de_datos

to disk='d:\datos.bak'

with init

go

backup database inversiones

to disk='d:\datos.bak'

go

backup database innovasoft

to disk='d:\datos.bak'

go

--restore inversiones to new db

restore database db2_2

from disk='d:\datos.bak'

with file=2,replace,

move 'inversiones' to 'd:\database\db2_2.mdf',

move 'inversiones_log' to 'd:\database\db2_2.ldf'

go

There was no problem with the backup commands but with the restore part the result was:

Msg 3234, Level 16, State 2, Line 1

El archivo lógico 'inversiones' no es parte de la base de datos 'db2_2'. Use RESTORE FILELISTONLY para enumerar los nombres de los archivos lógicos.

Msg 3013, Level 16, State 1, Line 1

Fin anómalo de RESTORE DATABASE.

As you can see, the problem is exactly the same i gave when doing the task with the Management Studio

Thanks in advance

|||

I think the data & log filenames may not have the standard naming conventions. Test this out.

Code Snippet

create database db4
on
(
name = db4_data,
filename = 'c:\db4_data.mdf',
size = 10,
maxsize = 40,
filegrowth = 5
)
log on
(
name = db4log_log,
filename = 'c:\db4_log.ldf',
size = 10,
maxsize = 40,
filegrowth = 5
)

backup database db4
to disk='c:\dbs1.bak'
with init
go

RESTORE FILELISTONLY FROM DISK = 'c:\dbs1.bak'
WITH FILE=1;

restore database db4_2
from disk='c:\dbs1.bak'
with file=1,replace,
move 'db2' to 'c:\db4_2.mdf',
move 'db2_log' to 'c:\db4_2.ldf'
go

It throws similar error what you are getting now. Above post from oj, works correctly, all you need to do get the filenames from the backup with the below code and substitute in the backup command.

Code Snippet

RESTORE FILELISTONLY FROM DISK = 'c:\dbs.bak'
WITH FILE=2;

|||

You need to get the correct logical names for the invensiones database.

Do:

Code Snippet

restore filelistonly from disk='d:\datos.bak' with file=2

Once you have the correct logical names you then can move the data files to new location.

|||

Thank you guys for your useful help.

One more question. This works excellent using transact sql is it possible to do the same using Management Studio. Because the problem began when i tried to run the restore under Management Studio.,

Than you.,

|||

Sure. You would want to make sure the logical names are valid. In fact, you should see the same t-sql statement if you launch profiler and watch it.

Error restoring a database

Please that anybody help me.

I have a phisical device called 'respaldo.bak' inside this file there are three backups of three different databases, The first one is database called 'innovasoft' the second one is 'modelo_de_datos' and the last one is 'Inversiones'.

If I perform a restore of the first one there is no problem, but, when i try to restore the second o third database i get the following error:

TITLE: Microsoft SQL Server Management Studio

Restore failed for Server 'COMPUTO'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

El archivo lógico 'INNOVASOFT_Datos' no es parte de la base de datos 'PROBANDO'. Use RESTORE FILELISTONLY para enumerar los nombres de los archivos lógicos.
Fin anómalo de RESTORE DATABASE. (Microsoft SQL Server, Error: 3234)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3234&LinkId=20476

BUTTONS:

OK

I have to say that i want to restore the database with a different name that's why in the error says 'PROBANDO' , i'm really concern about this problem because it means that i have no backups for my data. I used to use this procedure on sql server 2000 every single day without problems, but on sql server 2005 it doesn't work properly.

Please help me.

Thanks in advance.

Make sure you restore with a file destination plus move.

Here is a quick demo showing how it all works.

Code Snippet

--create 3 test dbs
use master
go
create database db1
go
create database db2
go
create database db3
go

--add dummy data to db2
exec db2..sp_executesql N'select db_name() [db] into db'
go

--backup dbs to disk
backup database db1
to disk='c:\dbs.bak'
with init
go
backup database db2
to disk='c:\dbs.bak'
go
backup database db3
to disk='c:\dbs.bak'
go

--restore db2 to new db
restore database db2_2
from disk='c:\dbs.bak'
with file=2,replace,
move 'db2' to 'c:\db2_2.mdf',
move 'db2_log' to 'c:\db2_2.ldf'
go

--check to make sure we actually restore db2
exec db2_2..sp_executesql N'select * from db'
go

--clean up
drop database db2_2, db3, db2, db1
go

|||

Hi, sorry that i answer until today. Well this was what i done

backup database modelo_de_datos

to disk='d:\datos.bak'

with init

go

backup database inversiones

to disk='d:\datos.bak'

go

backup database innovasoft

to disk='d:\datos.bak'

go

--restore inversiones to new db

restore database db2_2

from disk='d:\datos.bak'

with file=2,replace,

move 'inversiones' to 'd:\database\db2_2.mdf',

move 'inversiones_log' to 'd:\database\db2_2.ldf'

go

There was no problem with the backup commands but with the restore part the result was:

Msg 3234, Level 16, State 2, Line 1

El archivo lógico 'inversiones' no es parte de la base de datos 'db2_2'. Use RESTORE FILELISTONLY para enumerar los nombres de los archivos lógicos.

Msg 3013, Level 16, State 1, Line 1

Fin anómalo de RESTORE DATABASE.

As you can see, the problem is exactly the same i gave when doing the task with the Management Studio

Thanks in advance

|||

I think the data & log filenames may not have the standard naming conventions. Test this out.

Code Snippet

create database db4
on
(
name = db4_data,
filename = 'c:\db4_data.mdf',
size = 10,
maxsize = 40,
filegrowth = 5
)
log on
(
name = db4log_log,
filename = 'c:\db4_log.ldf',
size = 10,
maxsize = 40,
filegrowth = 5
)

backup database db4
to disk='c:\dbs1.bak'
with init
go

RESTORE FILELISTONLY FROM DISK = 'c:\dbs1.bak'
WITH FILE=1;

restore database db4_2
from disk='c:\dbs1.bak'
with file=1,replace,
move 'db2' to 'c:\db4_2.mdf',
move 'db2_log' to 'c:\db4_2.ldf'
go

It throws similar error what you are getting now. Above post from oj, works correctly, all you need to do get the filenames from the backup with the below code and substitute in the backup command.

Code Snippet

RESTORE FILELISTONLY FROM DISK = 'c:\dbs.bak'
WITH FILE=2;

|||

You need to get the correct logical names for the invensiones database.

Do:

Code Snippet

restore filelistonly from disk='d:\datos.bak' with file=2

Once you have the correct logical names you then can move the data files to new location.

|||

Thank you guys for your useful help.

One more question. This works excellent using transact sql is it possible to do the same using Management Studio. Because the problem began when i tried to run the restore under Management Studio.,

Than you.,

|||

Sure. You would want to make sure the logical names are valid. In fact, you should see the same t-sql statement if you launch profiler and watch it.

Error restoring a database

Please that anybody help me.

I have a phisical device called 'respaldo.bak' inside this file there are three backups of three different databases, The first one is database called 'innovasoft' the second one is 'modelo_de_datos' and the last one is 'Inversiones'.

If I perform a restore of the first one there is no problem, but, when i try to restore the second o third database i get the following error:

TITLE: Microsoft SQL Server Management Studio

Restore failed for Server 'COMPUTO'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

El archivo lógico 'INNOVASOFT_Datos' no es parte de la base de datos 'PROBANDO'. Use RESTORE FILELISTONLY para enumerar los nombres de los archivos lógicos.
Fin anómalo de RESTORE DATABASE. (Microsoft SQL Server, Error: 3234)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3234&LinkId=20476

BUTTONS:

OK

I have to say that i want to restore the database with a different name that's why in the error says 'PROBANDO' , i'm really concern about this problem because it means that i have no backups for my data. I used to use this procedure on sql server 2000 every single day without problems, but on sql server 2005 it doesn't work properly.

Please help me.

Thanks in advance.

Make sure you restore with a file destination plus move.

Here is a quick demo showing how it all works.

Code Snippet

--create 3 test dbs
use master
go
create database db1
go
create database db2
go
create database db3
go

--add dummy data to db2
exec db2..sp_executesql N'select db_name() [db] into db'
go

--backup dbs to disk
backup database db1
to disk='c:\dbs.bak'
with init
go
backup database db2
to disk='c:\dbs.bak'
go
backup database db3
to disk='c:\dbs.bak'
go

--restore db2 to new db
restore database db2_2
from disk='c:\dbs.bak'
with file=2,replace,
move 'db2' to 'c:\db2_2.mdf',
move 'db2_log' to 'c:\db2_2.ldf'
go

--check to make sure we actually restore db2
exec db2_2..sp_executesql N'select * from db'
go

--clean up
drop database db2_2, db3, db2, db1
go

|||

Hi, sorry that i answer until today. Well this was what i done

backup database modelo_de_datos

to disk='d:\datos.bak'

with init

go

backup database inversiones

to disk='d:\datos.bak'

go

backup database innovasoft

to disk='d:\datos.bak'

go

--restore inversiones to new db

restore database db2_2

from disk='d:\datos.bak'

with file=2,replace,

move 'inversiones' to 'd:\database\db2_2.mdf',

move 'inversiones_log' to 'd:\database\db2_2.ldf'

go

There was no problem with the backup commands but with the restore part the result was:

Msg 3234, Level 16, State 2, Line 1

El archivo lógico 'inversiones' no es parte de la base de datos 'db2_2'. Use RESTORE FILELISTONLY para enumerar los nombres de los archivos lógicos.

Msg 3013, Level 16, State 1, Line 1

Fin anómalo de RESTORE DATABASE.

As you can see, the problem is exactly the same i gave when doing the task with the Management Studio

Thanks in advance

|||

I think the data & log filenames may not have the standard naming conventions. Test this out.

Code Snippet

create database db4
on
(
name = db4_data,
filename = 'c:\db4_data.mdf',
size = 10,
maxsize = 40,
filegrowth = 5
)
log on
(
name = db4log_log,
filename = 'c:\db4_log.ldf',
size = 10,
maxsize = 40,
filegrowth = 5
)

backup database db4
to disk='c:\dbs1.bak'
with init
go

RESTORE FILELISTONLY FROM DISK = 'c:\dbs1.bak'
WITH FILE=1;

restore database db4_2
from disk='c:\dbs1.bak'
with file=1,replace,
move 'db2' to 'c:\db4_2.mdf',
move 'db2_log' to 'c:\db4_2.ldf'
go

It throws similar error what you are getting now. Above post from oj, works correctly, all you need to do get the filenames from the backup with the below code and substitute in the backup command.

Code Snippet

RESTORE FILELISTONLY FROM DISK = 'c:\dbs.bak'
WITH FILE=2;

|||

You need to get the correct logical names for the invensiones database.

Do:

Code Snippet

restore filelistonly from disk='d:\datos.bak' with file=2

Once you have the correct logical names you then can move the data files to new location.

|||

Thank you guys for your useful help.

One more question. This works excellent using transact sql is it possible to do the same using Management Studio. Because the problem began when i tried to run the restore under Management Studio.,

Than you.,

|||

Sure. You would want to make sure the logical names are valid. In fact, you should see the same t-sql statement if you launch profiler and watch it.

Error Restore of Database

HI,

While restoring a database from a backup file having extension .back we are getting the following error
"back is not part of the multiple family media set backup with format can be used to form a new media set"

Please guide me how to handle this error.

Thanks,
KarthikI have got informative link...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=915089&SiteID=1

Error Reporting service

hi
i am using SQL Server 2005 reporting services, i am getting an error message while deploying .rdl file error is:" Connection could not be established to remote server http://localhost/ReportServer"
Additional information is :
"client found response content type of text/html; charset=utf-8 but expected text/XML"Are you just trying to connect through the browser or to upload a file?|||Oh sorry I see. Are you able to connet to the instance through the browser?|||now its working properly, i have executed aspnet_regsql -ga aspnet commond on command prompt. But now while deploying i m getting another problem: "An internal error occurred on the report server. See the error log for more details."

Error Regarding file import through import wizard

Hi all,

when trying to ímport files to our database server from a client, I keep getting an error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)

... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.

I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.

best regards

Musa Rusid

I have encountered the same error trying to import flat files created from Excel sheets. What is the solution? Thanks.

Error Regarding file import through import wizard

Hi all,

when trying to ímport files to our database server from a client, I keep getting an error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)

... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.

I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.

best regards

Musa Rusid

I have encountered the same error trying to import flat files created from Excel sheets. What is the solution? Thanks.

error redirect to one file

Hi!

I have several lookups in my data flow task and for each of these I want to redirect error to one file (append data)

I created Flat File connection manager and first lookup goes fine with errors redirected to the file.

However, second error redirect that I am sending to the same file is failing.

Error I get is:

"[Flat File Destination 1 [14851]] Warning: The process cannot access the file because it is being used by another process.”

So my goal is to have one central file where I would redirect all records that fail.

thanks

Take all of the lookup error outputs and combine them with a union all component. Then, from the union all component go into your flat file destination.sql

error querying SQL Server from web page

We have a problem with an asp file retrieving data from SQL Server v7 databa
ses in
our test environment. The asp file opens a recordset to get a list of active
project
databases from another database table. The asp file loops through the record
set and
builds two SQL strings using the loop's current project database name to ret
rieve
counts from each project database. The counts are displayed in a table on a
web page.
Each SQL string is used to open a recordset against the loop's current proje
ct database.
The asp file worked fine until recently. Two new project databases were crea
ted by
backing up an existing database and restoring it with the new project names.
There
is a flag that we turn on to activate a project database. As soon as the new
projects
were turned on, the asp file failed with OLE DB error 0x80040E21. The error
message
indicated that the failure occurred when trying to open the first of the two
recordsets
associated with the two SQL strings that were being created. When we turned
off the new
projects, then everything worked fine again.
We started a trace in SQL Server and found that the SQL string being execute
d changed
when we added one of the new projects.
The SQL string for the old projects looked like:
N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE...
in which I have used 'server' to represent the SQL Server name and 'projectd
b' to
represent the project database name. The server name is always the same; onl
y the
project database name changes.
When one of the new projects was reached in the loop, the SQL string started
out the
same as above. But at some point the query changes to:
N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WH
ERE...
The query tanks and so does the asp file. A developer searched for postings
relating to the
OLE DB error and saw something about NULLs. Since it was possible for the qu
ery to return NULL,
he tried changing the query in the asp file to:
N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets WHERE
..
This fixed the problem as the query succeeded for all of the project databas
es, old and new.
The question is why this fixed the problem and how did the original query pi
ck up the additional
text "select * from". Because -
1. Upon checking the project databases, there were old project databases tha
t returned NULLs to the
queries. These project databases didn't have a problem when queried by the o
riginal asp file.
2. The new project databases were loaded with data so that they didn't retur
n NULLs. They still
caused the old asp file to fail.
3. In case the problem was with NULLs returned by an old project database pr
eceding or following
the new project database we varied which project databases were turned on. T
his didn't affect the
results at all as the asp file always failed when it came to a new project d
atabase.
So the isNull function somehow cleared up the problem even though the proble
m doesn't appear to
relate to whether NULLs are returned by the original queries.
Other things we tried that didn't help -
1. scripting the database install rather than backup\restore
2. logging on to the SQL Server box directly and installing the new database
rather than doing it
remotely with a SQL Server client
The web server and the database server are both running Windows 2000 Server
5.0.2195 SP4 Build 2195.
The SQL Server version is 7.00.624.
Can someone shed some light on this?That is a very interesting problem... I am curious, does the problem go
away if you do NOT use the 4 part name... SQL may do some strange things
when using the 4-part name because the data could be coming from a linked
server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Pat Hurst" <anonymous@.discussions.microsoft.com> wrote in message
news:98D3FE8E-D08A-4C8D-8614-8261C877687A@.microsoft.com...
> We have a problem with an asp file retrieving data from SQL Server v7
databases in
> our test environment. The asp file opens a recordset to get a list of
active project
> databases from another database table. The asp file loops through the
recordset and
> builds two SQL strings using the loop's current project database name to
retrieve
> counts from each project database. The counts are displayed in a table on
a web page.
> Each SQL string is used to open a recordset against the loop's current
project database.
> The asp file worked fine until recently. Two new project databases were
created by
> backing up an existing database and restoring it with the new project
names. There
> is a flag that we turn on to activate a project database. As soon as the
new projects
> were turned on, the asp file failed with OLE DB error 0x80040E21. The
error message
> indicated that the failure occurred when trying to open the first of the
two recordsets
> associated with the two SQL strings that were being created. When we
turned off the new
> projects, then everything worked fine again.
> We started a trace in SQL Server and found that the SQL string being
executed changed
> when we added one of the new projects.
> The SQL string for the old projects looked like:
> N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE...
> in which I have used 'server' to represent the SQL Server name and
'projectdb' to
> represent the project database name. The server name is always the same;
only the
> project database name changes.
> When one of the new projects was reached in the loop, the SQL string
started out the
> same as above. But at some point the query changes to:
> N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets
WHERE...
> The query tanks and so does the asp file. A developer searched for
postings relating to the
> OLE DB error and saw something about NULLs. Since it was possible for the
query to return NULL,
> he tried changing the query in the asp file to:
> N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets
WHERE...
> This fixed the problem as the query succeeded for all of the project
databases, old and new.
> The question is why this fixed the problem and how did the original query
pick up the additional
> text "select * from". Because -
> 1. Upon checking the project databases, there were old project databases
that returned NULLs to the
> queries. These project databases didn't have a problem when queried by the
original asp file.
> 2. The new project databases were loaded with data so that they didn't
return NULLs. They still
> caused the old asp file to fail.
> 3. In case the problem was with NULLs returned by an old project database
preceding or following
> the new project database we varied which project databases were turned on.
This didn't affect the
> results at all as the asp file always failed when it came to a new project
database.
> So the isNull function somehow cleared up the problem even though the
problem doesn't appear to
> relate to whether NULLs are returned by the original queries.
> Other things we tried that didn't help -
> 1. scripting the database install rather than backup\restore
> 2. logging on to the SQL Server box directly and installing the new
database rather than doing it
> remotely with a SQL Server client
> The web server and the database server are both running Windows 2000
Server 5.0.2195 SP4 Build 2195.
> The SQL Server version is 7.00.624.
> Can someone shed some light on this?|||May I congratulate you on your prescience. I removed the server name from th
e 2 queries in the asp file and omitted the IsNull function from both. The w
eb page came up without a hitch.
It appears that the code specifies the server name earlier in setting up a c
onnection object. This connection is used to open the 2 query recordsets so
I'm not sure why the server name was used in specifying the table in the que
ries. The developer who wro
te it is out of the office currently so I can't ask him.
Still I can't help wondering why only the two new databases created a proble
m.|||After tracking down a developer with access to the production system, I was
able to find out that production uses 2 database servers. The primary holds
the system's database and some of the project databases. The other holds a f
ew of the project databases
. The two are linked in SQL Server. So that's the rationale for four part na
mes.
Our test environment can only afford one database server so a four part name
is unnecessary as the projects are all on the server that the web page conn
ects to.

error querying SQL Server from web page

We have a problem with an asp file retrieving data from SQL Server v7 databases i
our test environment. The asp file opens a recordset to get a list of active project
databases from another database table. The asp file loops through the recordset and
builds two SQL strings using the loop's current project database name to retrieve
counts from each project database. The counts are displayed in a table on a web page.
Each SQL string is used to open a recordset against the loop's current project database
The asp file worked fine until recently. Two new project databases were created b
backing up an existing database and restoring it with the new project names. Ther
is a flag that we turn on to activate a project database. As soon as the new projects
were turned on, the asp file failed with OLE DB error 0x80040E21. The error message
indicated that the failure occurred when trying to open the first of the two recordsets
associated with the two SQL strings that were being created. When we turned off the new
projects, then everything worked fine again
We started a trace in SQL Server and found that the SQL string being executed changed
when we added one of the new projects
The SQL string for the old projects looked like
N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE..
in which I have used 'server' to represent the SQL Server name and 'projectdb' to
represent the project database name. The server name is always the same; only the
project database name changes
When one of the new projects was reached in the loop, the SQL string started out th
same as above. But at some point the query changes to
N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE..
The query tanks and so does the asp file. A developer searched for postings relating to the
OLE DB error and saw something about NULLs. Since it was possible for the query to return NULL
he tried changing the query in the asp file to
N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets WHERE..
This fixed the problem as the query succeeded for all of the project databases, old and new
The question is why this fixed the problem and how did the original query pick up the additiona
text "select * from". Because
1. Upon checking the project databases, there were old project databases that returned NULLs to the
queries. These project databases didn't have a problem when queried by the original asp file
2. The new project databases were loaded with data so that they didn't return NULLs. They still
caused the old asp file to fail
3. In case the problem was with NULLs returned by an old project database preceding or following
the new project database we varied which project databases were turned on. This didn't affect the
results at all as the asp file always failed when it came to a new project database
So the isNull function somehow cleared up the problem even though the problem doesn't appear to
relate to whether NULLs are returned by the original queries
Other things we tried that didn't help
1. scripting the database install rather than backup\restor
2. logging on to the SQL Server box directly and installing the new database rather than doing it
remotely with a SQL Server clien
The web server and the database server are both running Windows 2000 Server 5.0.2195 SP4 Build 2195
The SQL Server version is 7.00.624
Can someone shed some light on this?That is a very interesting problem... I am curious, does the problem go
away if you do NOT use the 4 part name... SQL may do some strange things
when using the 4-part name because the data could be coming from a linked
server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Pat Hurst" <anonymous@.discussions.microsoft.com> wrote in message
news:98D3FE8E-D08A-4C8D-8614-8261C877687A@.microsoft.com...
> We have a problem with an asp file retrieving data from SQL Server v7
databases in
> our test environment. The asp file opens a recordset to get a list of
active project
> databases from another database table. The asp file loops through the
recordset and
> builds two SQL strings using the loop's current project database name to
retrieve
> counts from each project database. The counts are displayed in a table on
a web page.
> Each SQL string is used to open a recordset against the loop's current
project database.
> The asp file worked fine until recently. Two new project databases were
created by
> backing up an existing database and restoring it with the new project
names. There
> is a flag that we turn on to activate a project database. As soon as the
new projects
> were turned on, the asp file failed with OLE DB error 0x80040E21. The
error message
> indicated that the failure occurred when trying to open the first of the
two recordsets
> associated with the two SQL strings that were being created. When we
turned off the new
> projects, then everything worked fine again.
> We started a trace in SQL Server and found that the SQL string being
executed changed
> when we added one of the new projects.
> The SQL string for the old projects looked like:
> N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE...
> in which I have used 'server' to represent the SQL Server name and
'projectdb' to
> represent the project database name. The server name is always the same;
only the
> project database name changes.
> When one of the new projects was reached in the loop, the SQL string
started out the
> same as above. But at some point the query changes to:
> N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets
WHERE...
> The query tanks and so does the asp file. A developer searched for
postings relating to the
> OLE DB error and saw something about NULLs. Since it was possible for the
query to return NULL,
> he tried changing the query in the asp file to:
> N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets
WHERE...
> This fixed the problem as the query succeeded for all of the project
databases, old and new.
> The question is why this fixed the problem and how did the original query
pick up the additional
> text "select * from". Because -
> 1. Upon checking the project databases, there were old project databases
that returned NULLs to the
> queries. These project databases didn't have a problem when queried by the
original asp file.
> 2. The new project databases were loaded with data so that they didn't
return NULLs. They still
> caused the old asp file to fail.
> 3. In case the problem was with NULLs returned by an old project database
preceding or following
> the new project database we varied which project databases were turned on.
This didn't affect the
> results at all as the asp file always failed when it came to a new project
database.
> So the isNull function somehow cleared up the problem even though the
problem doesn't appear to
> relate to whether NULLs are returned by the original queries.
> Other things we tried that didn't help -
> 1. scripting the database install rather than backup\restore
> 2. logging on to the SQL Server box directly and installing the new
database rather than doing it
> remotely with a SQL Server client
> The web server and the database server are both running Windows 2000
Server 5.0.2195 SP4 Build 2195.
> The SQL Server version is 7.00.624.
> Can someone shed some light on this?|||May I congratulate you on your prescience. I removed the server name from the 2 queries in the asp file and omitted the IsNull function from both. The web page came up without a hitch
It appears that the code specifies the server name earlier in setting up a connection object. This connection is used to open the 2 query recordsets so I'm not sure why the server name was used in specifying the table in the queries. The developer who wrote it is out of the office currently so I can't ask him
Still I can't help wondering why only the two new databases created a problem.

Error Printing using Adobe

Hi,
In rs2005 I am trying to print the report to a pdf file - export is not
an option as I cannot embed the fonts. When I click on the print
setting I get the following Adobe error.
Unable to find "Adobe PDF" resource files.
"C:\doc and settings\al users\documents\adobe
pdf\settings\nt\SC_Black-and-White.joboptions"
Do you want to run the installer in repair mode?
Anyone else experience this?
Every other application can print fine even rs2000
thanksanyone?
seanlacey@.gmail.com wrote:
> Hi,
> In rs2005 I am trying to print the report to a pdf file - export is not
> an option as I cannot embed the fonts. When I click on the print
> setting I get the following Adobe error.
> Unable to find "Adobe PDF" resource files.
> "C:\doc and settings\al users\documents\adobe
> pdf\settings\nt\SC_Black-and-White.joboptions"
> Do you want to run the installer in repair mode?
>
> Anyone else experience this?
> Every other application can print fine even rs2000
> thanks

error pending file

I've uninstall my previous sql2000 developer edition with leave some dll file undeleted.

once I tried to reinstall the sqlserver, the installation setup stop the process with message: A previous installation created pending file operations on the installation machine.
you must restart the computer before running setup.

I fail in continueing setup although i've restart the pc.

What should i do to handle this?

Regards,

BHT

Hhh.... please someone help me...

I don't want to reinstall the O/S as previously i've done. headache and waisting my days.

Regards,

BHT

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b312995&Product=sql

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

At last I saved. Thank you for your help.

Trully it is very suffer when become a begginer. (

Regards,

BHT

Error output question

Hello,

I realize I have a question about what constitutes an "error" for an error output.

For example, a flat file source has an error output for "bad rows", that is, when it encounters "unexpected data". What specifically is "unexpected data"? Is this documented somewhere?

Another example would be an OLE DB source that uses a query to retrieve row. This too, has an error output, but I realize I have no clue what would constitute bad data from a table. I mean, data in a table is just data, so what would constitute an error from an OLE DB source? I can't think of one thing. Where are these "rules" documented, if anywhere?

Thanks

"Handling Errors in Data" in Books Online has some great information on this.

Errors can be different for different components. Sources most often suffer from data type conversion issues. The error output adds an ErrorCode and you can call Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData90.GetErrorDescription in a script component to see the actual error message.

Error on replication

Hi,
when i try to run an push-replication on MS SQL 2000
i get the error "Log file is full" on the subscriber.
I tried to make this grow VERY much, but it doesnt help.
The table that fails has over 75000 posts, so maybe that is an issue.

The error occurs when i for the first time tries to sync it...

Any ideas?

// PeterTry breaking your task into smaller units of work.

You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.

Good Luck,|||Well, the thing is... i only want to replicate this to a server, and not
run any scripts. Shouldnt MS-SQL handle this?

I tried the push-operation without the LARGE-table (75000 posts)
and it worked. So it has something to do with that.
Any more suggestions?

Please?!!

// Peter

Originally posted by Bruce A. Baasch
Try breaking your task into smaller units of work.

You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.

Good Luck,sql

Error on Install

I'm getting an error when trying to install the SQL Server 2005 Express. After it installs the Native Client & Support file, it goes through a configuration check.

I'm getting this error (complete) ::

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154)

and then stops.

Suggestions would be great!!!

Check here:

http://support.microsoft.com/default.aspx/kb/201234

Buck Woody

|||

Re-registering WMI

I've been having some issues with WMI on my laptop over the past couple of weeks (the symptoms of which have been strange WMI repository messages, inability to run WMIC or scripts, machine running slower than usual etc.). I didn't really want to have to re-install or repair Windows to fix this. Fortunately I found this very helpful article on resetting and re-registering the WMI services.

This included the following commands to re-register all of the WMI components:

cd /d %windir%\system32\wbem

for %i in (*.dll) do RegSvr32 -s %i

for %i in (*.exe) do %i /RegServer

Published Friday, March 18, 2005 5:19 PM by smguest

I did this, worked for me.

Error on Install

I'm getting an error when trying to install the SQL Server 2005 Express. After it installs the Native Client & Support file, it goes through a configuration check.

I'm getting this error (complete) ::

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154)

and then stops.

Suggestions would be great!!!

Check here:

http://support.microsoft.com/default.aspx/kb/201234

Buck Woody

|||

Re-registering WMI

I've been having some issues with WMI on my laptop over the past couple of weeks (the symptoms of which have been strange WMI repository messages, inability to run WMIC or scripts, machine running slower than usual etc.). I didn't really want to have to re-install or repair Windows to fix this. Fortunately I found this very helpful article on resetting and re-registering the WMI services.

This included the following commands to re-register all of the WMI components:

cd /d %windir%\system32\wbem

for %i in (*.dll) do RegSvr32 -s %i

for %i in (*.exe) do %i /RegServer

Published Friday, March 18, 2005 5:19 PM by smguest

I did this, worked for me.

sql

Error on Importing datather PRIMARY FILE GROUP IS FULL

I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL
As the message is indicating, your primary file group where the table exists
is full. You will have to set the file to autogrow, if it isn't already (see
ALTER DATABASE in Books Online). Also, make sure, you have enough free space
on your data disk.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL
|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am trying to import data from one table to another on different servers.
>
> Could not allocate space for object microfilmacion in database Dbsiab
> because ther PRIMARY FILE GROUP IS FULL
>
|||How can I do that? I didnt understand.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
servers.
>
|||Assuming you are using Outlook Express when you create the post it will have
a section at the top titled "NewsGroups". Normally it will fill in the name
of the group in which you are currently in but you can click on the Icon to
the left of it and choose all the groups you wish this post to appear. Then
when someone answers in one newsgroup it will appear in all of them.
Good luck,
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:eUp%23QsshEHA.3200@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> How can I do that? I didnt understand.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
one.
> servers.
>

Error on Importing datather PRIMARY FILE GROUP IS FULL

I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULLAs the message is indicating, your primary file group where the table exists
is full. You will have to set the file to autogrow, if it isn't already (see
ALTER DATABASE in Books Online). Also, make sure, you have enough free space
on your data disk.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am trying to import data from one table to another on different servers.
>
> Could not allocate space for object microfilmacion in database Dbsiab
> because ther PRIMARY FILE GROUP IS FULL
>|||How can I do that? I didnt understand.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
servers.[vbcol=seagreen]
>|||Assuming you are using Outlook Express when you create the post it will have
a section at the top titled "NewsGroups". Normally it will fill in the name
of the group in which you are currently in but you can click on the Icon to
the left of it and choose all the groups you wish this post to appear. Then
when someone answers in one newsgroup it will appear in all of them.
Good luck,
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:eUp%23QsshEHA.3200@.TK2MSFTNGP10.phx.gbl...
> How can I do that? I didnt understand.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
one.[vbcol=seagreen]
> servers.
>

Error on Importing datather PRIMARY FILE GROUP IS FULL

I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULLAs the message is indicating, your primary file group where the table exists
is full. You will have to set the file to autogrow, if it isn't already (see
ALTER DATABASE in Books Online). Also, make sure, you have enough free space
on your data disk.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am trying to import data from one table to another on different servers.
>
> Could not allocate space for object microfilmacion in database Dbsiab
> because ther PRIMARY FILE GROUP IS FULL
>|||How can I do that? I didnt understand.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribió en el mensaje
news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > I am trying to import data from one table to another on different
servers.
> >
> >
> > Could not allocate space for object microfilmacion in database Dbsiab
> > because ther PRIMARY FILE GROUP IS FULL
> >
> >
>|||Assuming you are using Outlook Express when you create the post it will have
a section at the top titled "NewsGroups". Normally it will fill in the name
of the group in which you are currently in but you can click on the Icon to
the left of it and choose all the groups you wish this post to appear. Then
when someone answers in one newsgroup it will appear in all of them.
Good luck,
--
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:eUp%23QsshEHA.3200@.TK2MSFTNGP10.phx.gbl...
> How can I do that? I didnt understand.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribió en el mensaje
> news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
> > Please don't post independently in separate newsgroups. You can add
> > multiple newsgroups to the header and then all the answers appear as
one.
> > See my reply in the other newsgroup.
> >
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> > news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > I am trying to import data from one table to another on different
> servers.
> > >
> > >
> > > Could not allocate space for object microfilmacion in database Dbsiab
> > > because ther PRIMARY FILE GROUP IS FULL
> > >
> > >
> >
> >
>sql

Error on creating cube file from Excel 2003, AS 2005

Hi,

I tried to create a cube file in Excel 2003. Data source is SSAS 2005.

On the last step of wizard I get the following error:
Microsoft OLE DB Provider for Analysis Services 2005:
Query (3,2) Parser: The syntax for 'DIMENSION' is incorrect.

Seems like a bug. Is there any fix?
Tried to search google, found nothing...

SQL Server 2005 Developer SP2
Excell 2003 SP2

Thx for any tip...

certainly sounds like a bug. Can you provide a repro' that the product team can look at?

thanks,

Bala.