Thursday, March 29, 2012
Error 927
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesIf you run sp_who2 do you see any RESTORE spids ? If not it may well be that
you just need to run RESTORE DATABASE dbname WITH RECOVERY to recover and
access the database.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<James@.discussions.microsoft.com> wrote in message
news:045601c3cfb6$8a186d40$a001280a@.phx.gbl...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>|||Hi James,
How did you restore the database? Are you using any third party tool?
Certain third party tool such as Arcserv may have option for you to
"recover" the database after the restore. If not, it will stay in
loading status until you recover the database manually
To recover the database manually, you can just run the following
statement
restore database <dbname> with recovery
Yih-Yoon Lee
<James@.discussions.microsoft.com> wrote in message news:<045601c3cfb6$8a186d40$a001280a@.phx.gbl>...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
Error 927
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesThat is really hard to tell. 12 hours sounds a bit excessive. What version
of SQL? I've restored 1-2 GB databases with SQL 7/2000 in 30 mins.
My one thought is that there may be a very long running transaction that has
to be rolled back. Do you have another backup to try restoring from? You
could always create a separate database on the same server, and force a
restore on that one.
Also, does sp_who reveal any blocks or ROLLBACK transactions? Where is
error 927 show up? When you restored, on the Advanced tab, it did say Leave
database operational, and not one of the other options where you could
restore additional backups, right?
I assume this KB article is not applicable as it is for the msdb database,
but I'll put in just in case
http://support.microsoft.com/defaul...kb;en-us;319701 (Error 927
restoring the msdb database).
Good luck.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
<James@.discussions.microsoft.com> wrote in message
news:045b01c3cfb6$9d4f18f0$a001280a@.phx.gbl...
quote:sql
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>
Thursday, March 22, 2012
Error 8115 in Enterprise Manager when I want to shrink my attached Database
I get Error 8115 "... Arithmetic overflow convertion numeric in datatype
numeric ..." when I want to shrink my database after attaching to sql server
2000.
No error occurs when I shrink my database with the query analyzer.
No error is reported when I try DBCC DBCHECK on the database.
So, whats the problem for the Enterprise Manager?
It's not only on my PC ... it occurs on other PCs too after attaching the
database to sql server 2000.
Any ideas?
Thanks und Greetings
MartinMy guess is a programming mistake in either EM or DMO. Does this happen when you open the shrink
dialog or when you press "OK"?
Is it a large database? Does it have many database files?
My guess is that EM or DMO executes some SQL statement that causes an overflow in the SQL code,
quite simply. Perhaps there's a KB article on this. Did you check? I ran profiler when opening the
dialog, and I can possibly see why an overflow can occur if you have strange figures in sysfiles, or
if you have many or large database...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Martin Schmeller" <martin.schmeller@.mcs-ag.com> wrote in message
news:exSk8soDFHA.3824@.TK2MSFTNGP10.phx.gbl...
> Hallo everbody,
> I get Error 8115 "... Arithmetic overflow convertion numeric in datatype
> numeric ..." when I want to shrink my database after attaching to sql server
> 2000.
> No error occurs when I shrink my database with the query analyzer.
> No error is reported when I try DBCC DBCHECK on the database.
> So, whats the problem for the Enterprise Manager?
> It's not only on my PC ... it occurs on other PCs too after attaching the
> database to sql server 2000.
> Any ideas?
> Thanks und Greetings
> Martin
>
Error 8115 in Enterprise Manager when I want to shrink my attached Database
I get Error 8115 "... Arithmetic overflow convertion numeric in datatype
numeric ..." when I want to shrink my database after attaching to sql server
2000.
No error occurs when I shrink my database with the query analyzer.
No error is reported when I try DBCC DBCHECK on the database.
So, whats the problem for the Enterprise Manager?
It's not only on my PC ... it occurs on other PCs too after attaching the
database to sql server 2000.
Any ideas?
Thanks und Greetings
Martin
My guess is a programming mistake in either EM or DMO. Does this happen when you open the shrink
dialog or when you press "OK"?
Is it a large database? Does it have many database files?
My guess is that EM or DMO executes some SQL statement that causes an overflow in the SQL code,
quite simply. Perhaps there's a KB article on this. Did you check? I ran profiler when opening the
dialog, and I can possibly see why an overflow can occur if you have strange figures in sysfiles, or
if you have many or large database...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Martin Schmeller" <martin.schmeller@.mcs-ag.com> wrote in message
news:exSk8soDFHA.3824@.TK2MSFTNGP10.phx.gbl...
> Hallo everbody,
> I get Error 8115 "... Arithmetic overflow convertion numeric in datatype
> numeric ..." when I want to shrink my database after attaching to sql server
> 2000.
> No error occurs when I shrink my database with the query analyzer.
> No error is reported when I try DBCC DBCHECK on the database.
> So, whats the problem for the Enterprise Manager?
> It's not only on my PC ... it occurs on other PCs too after attaching the
> database to sql server 2000.
> Any ideas?
> Thanks und Greetings
> Martin
>
Error 8115 in Enterprise Manager when I want to shrink my attached Database
I get Error 8115 "... Arithmetic overflow convertion numeric in datatype
numeric ..." when I want to shrink my database after attaching to sql server
2000.
No error occurs when I shrink my database with the query analyzer.
No error is reported when I try DBCC DBCHECK on the database.
So, whats the problem for the Enterprise Manager?
It's not only on my PC ... it occurs on other PCs too after attaching the
database to sql server 2000.
Any ideas?
Thanks und Greetings
MartinMy guess is a programming mistake in either EM or DMO. Does this happen when
you open the shrink
dialog or when you press "OK"?
Is it a large database? Does it have many database files?
My guess is that EM or DMO executes some SQL statement that causes an overfl
ow in the SQL code,
quite simply. Perhaps there's a KB article on this. Did you check? I ran pro
filer when opening the
dialog, and I can possibly see why an overflow can occur if you have strange
figures in sysfiles, or
if you have many or large database...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Martin Schmeller" <martin.schmeller@.mcs-ag.com> wrote in message
news:exSk8soDFHA.3824@.TK2MSFTNGP10.phx.gbl...
> Hallo everbody,
> I get Error 8115 "... Arithmetic overflow convertion numeric in datatype
> numeric ..." when I want to shrink my database after attaching to sql serv
er
> 2000.
> No error occurs when I shrink my database with the query analyzer.
> No error is reported when I try DBCC DBCHECK on the database.
> So, whats the problem for the Enterprise Manager?
> It's not only on my PC ... it occurs on other PCs too after attaching the
> database to sql server 2000.
> Any ideas?
> Thanks und Greetings
> Martin
>
Monday, March 19, 2012
Error 7302
I am getting the following error after I create a linked
server using Enterprise Manager on an SQL2K machine:
Error 7302: Could not create an instance of OLE DB
provider 'SQLOLEDB' error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned 0x80004002].
The linked server is created OK, this error comes up when
trying to browse tables/views.
I have ServicePack3.
Thanks!Audrey
What is the linked server type?
J|||Make sure that the OLE DB
provider 'SQLOLEDB file is registered correctly. Use RegSvr32.exe to register the Microsoft OLE DB provider for that provider. If the registration fails, reinstall your MDAC components. For more information about MDAC, refer to this Web site:
http://microsoft.com/data/
Here is registry key refers to the provider name :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Providers\ProviderName|||Originally posted by SQLSurfer
Audrey
What is the linked server type?
J
Linked server type is MSSQL2000.|||Originally posted by Satya
Make sure that the OLE DB
provider 'SQLOLEDB file is registered correctly. Use RegSvr32.exe to register the Microsoft OLE DB provider for that provider. If the registration fails, reinstall your MDAC components. For more information about MDAC, refer to this Web site:
http://microsoft.com/data/
Here is registry key refers to the provider name :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Providers\ProviderName
Registration passes correctly, but she does not help.
Sunday, March 11, 2012
Error 6107
I got an error when I tried to clear users ( Error 6107 --Only user
procesess can be killed)
I checked sp_who and realized that autoshrink is running.Is there anyway to
kill it.
When I tried kill <pid> from query Anz. same error -- Only user procesess
can be killed
ThanksI would recommend you wait for it to complete.
Another route would be shutting down sqlserver service. This is quite
drastic and error prone.
-oj
http://www.rac4sql.net
"Abraham" <binu_ca@.yahoo.com> wrote in message
news:uDz1gYe4DHA.1804@.TK2MSFTNGP12.phx.gbl...
quote:
> I tried to detach my database (using enterprise manager).
> I got an error when I tried to clear users ( Error 6107 --Only user
> procesess can be killed)
> I checked sp_who and realized that autoshrink is running.Is there anyway
to
quote:
> kill it.
> When I tried kill <pid> from query Anz. same error -- Only user procesess
> can be killed
> Thanks
>
Error 6107
I got an error when I tried to clear users ( Error 6107 --Only user
procesess can be killed)
I checked sp_who and realized that autoshrink is running.Is there anyway to
kill it.
When I tried kill <pid> from query Anz. same error -- Only user procesess
can be killed
ThanksI would recommend you wait for it to complete.
Another route would be shutting down sqlserver service. This is quite
drastic and error prone.
--
-oj
http://www.rac4sql.net
"Abraham" <binu_ca@.yahoo.com> wrote in message
news:uDz1gYe4DHA.1804@.TK2MSFTNGP12.phx.gbl...
> I tried to detach my database (using enterprise manager).
> I got an error when I tried to clear users ( Error 6107 --Only user
> procesess can be killed)
> I checked sp_who and realized that autoshrink is running.Is there anyway
to
> kill it.
> When I tried kill <pid> from query Anz. same error -- Only user procesess
> can be killed
> Thanks
>
Friday, March 9, 2012
Error 5149: Not enough disk space
Importing a 25,000,000 record .csv file into SQL2000 fails
with a disk space error. I go into sql enterprise manager
to increase the size of the database and it will only let
me go to about 4000 MB. I need about 30GIG. At 5000 MB
enterprise manager says:
Error 5149: ModifyFile encountered operating system error
112 (There is not enough space on the disk while
attempting to expand physical file).
I have 50GIG free on that disk.
What am I doing wrong'"Ben Silvert" <anonymous@.discussions.microsoft.com> wrote in message
news:1be701c39fc7$d4faa450$3101280a@.phx.gbl...
> Newbie question:
> Importing a 25,000,000 record .csv file into SQL2000 fails
> with a disk space error. I go into sql enterprise manager
> to increase the size of the database and it will only let
> me go to about 4000 MB. I need about 30GIG. At 5000 MB
> enterprise manager says:
> Error 5149: ModifyFile encountered operating system error
> 112 (There is not enough space on the disk while
> attempting to expand physical file).
> I have 50GIG free on that disk.
> What am I doing wrong'
It's possible that you are either running out of transaction log space (on
either the target database) or on tempdb -- check that you have enabled
database file autogrow, or have size the database large enough to hold the
imported data (my preference).
If this fails, you may want to watch the server os page file (performance
monitor) in case the os is swapping out memory to disk...
Steve|||I'm getting this error when I go into properties of the
database, Data Files tab, Space Allocated (MB) column. I
try to change the entry from 4000 to 5000, and it gives me
the 5149 error. I'm not trying to import the data, yet.
When I tried before to import the data it failed with a
message the Primary File Group ran out of space. So I
deleted the database, made a new one, and tried to set the
data file size, to no avail.
The database is set to grow automatically, and it grows
unlimited.
>--Original Message--
>"Ben Silvert" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1be701c39fc7$d4faa450$3101280a@.phx.gbl...
>> Newbie question:
>> Importing a 25,000,000 record .csv file into SQL2000
fails
>> with a disk space error. I go into sql enterprise
manager
>> to increase the size of the database and it will only
let
>> me go to about 4000 MB. I need about 30GIG. At 5000 MB
>> enterprise manager says:
>> Error 5149: ModifyFile encountered operating system
error
>> 112 (There is not enough space on the disk while
>> attempting to expand physical file).
>> I have 50GIG free on that disk.
>> What am I doing wrong'
>It's possible that you are either running out of
transaction log space (on
>either the target database) or on tempdb -- check that
you have enabled
>database file autogrow, or have size the database large
enough to hold the
>imported data (my preference).
>If this fails, you may want to watch the server os page
file (performance
>monitor) in case the os is swapping out memory to disk...
>Steve
>
>.
>|||Could it be the version of SQL? I have the personal
edition?
>--Original Message--
>Newbie question:
>Importing a 25,000,000 record .csv file into SQL2000
fails
>with a disk space error. I go into sql enterprise manager
>to increase the size of the database and it will only let
>me go to about 4000 MB. I need about 30GIG. At 5000 MB
>enterprise manager says:
>Error 5149: ModifyFile encountered operating system error
>112 (There is not enough space on the disk while
>attempting to expand physical file).
>I have 50GIG free on that disk.
>What am I doing wrong'
>.
>
Error 5123: CREATE FILE encountered operating system error 32
from the .BAK file in Enterprise Manager I got an error message about "Device
activation error. The physical filename...maybe incorrect. File...cannot be
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the console
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
Dennis
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root.
Are you saying that the restore executed without error message but you didn't see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Device
> activation error. The physical filename...maybe incorrect. File...cannot be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis
|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
Dennis
"Tibor Karaszi" wrote:
> Are you saying that the restore executed without error message but you didn't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
>
>
Error 5123: CREATE FILE encountered operating system error 32
from the .BAK file in Enterprise Manager I got an error message about "Devic
e
activation error. The physical filename...maybe incorrect. File...cannot b
e
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the consol
e
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
Dennis> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root.
Are you saying that the restore executed without error message but you didn'
t see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the da
tabase.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Dev
ice
> activation error. The physical filename...maybe incorrect. File...cannot
be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
--
Dennis
"Tibor Karaszi" wrote:
> Are you saying that the restore executed without error message but you did
n't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the
database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
>
>
Error 5123: CREATE FILE encountered operating system error 32
from the .BAK file in Enterprise Manager I got an error message about "Device
activation error. The physical filename...maybe incorrect. File...cannot be
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the console
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
--
Dennis> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root.
Are you saying that the restore executed without error message but you didn't see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Device
> activation error. The physical filename...maybe incorrect. File...cannot be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
--
Dennis
"Tibor Karaszi" wrote:
> > The 2 files are physically restored as named in the MOVE statement. In
> > Enterprise Manager the restored database name does not show up in the console
> > root.
> Are you saying that the restore executed without error message but you didn't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> > I'm moving a database from Server A to Server B. When I tried to restore
> > from the .BAK file in Enterprise Manager I got an error message about "Device
> > activation error. The physical filename...maybe incorrect. File...cannot be
> > restored to...Use WITH MOVE to identify a valid location for the file."
> >
> > So I tried to restore from Query Analyzer with...
> > RESTORE FILELISTONLY
> > FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> >
> > RESTORE DATABASE USQL_Data
> > FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> > WITH NORECOVERY,
> > MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> > MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> >
> > The 2 files are physically restored as named in the MOVE statement. In
> > Enterprise Manager the restored database name does not show up in the console
> > root. I tried to attach the restored database but get an error message
> > "Error 5123: CREATE FILE encountered operating system error 32..."
> >
> > What do I need to do to use the restored database in Enterprise Manager?
> >
> > --
> > Dennis
>
>
Error 5 when creating a subscription
After pushing a subscription I get an error:
SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server '***'.
5 - (Access is denied)
How can I fix that?
Thanks in advance,
MikeSounds like the account on the publisher needs rights on the subscriber...
just a shot in the dark...|||How do I set these rights? I am not sure where I need to look for that information. I have admin rights on both servers.
Error 5 (Access Denied) and Named Pipes Provider error 40
Hello there,
I recently started having trouble with my local SQL Server 8.0 database server. When I try to start it with Enterprise Manager I get the following error:
An error 5 - (Access is denied) occured while performing this service operation on the MSSQLServer service.
Nothing showed up in the SQL Server error logs. If I try to connect to it using the SQL Server Management Studio that came with SQL Server 2005 I get the following (slightly more informative) message:
Cannot connect to (local) ... (provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
I'm not sure which log to look at in the MSSQL folders: MSSQL.1, MSSQL.2 or MSSQL.3.
Furthermore, if I manually start the MSSQLSERVER service, then I can connect just fine with the SQL Server 2005 Management Studio but still get the weird error message with SQL Server 8.0 Enterprise Manager.
Any ideas?
Thanks
Nevermind, I figured out that I had changed the name of my computer. I changed the name back and can now connect to the server just fine.Wednesday, March 7, 2012
Error 404 Report Manager
postings and found nothing useful. I had no problem accessing report manager
for a long time, and then all of a sudden I get HTTP 404 error OBject Not
Found. Nothing was changed in IIS, Reports virtual directory, and I'm not
using SSL.
If anyone has any actual experience in successfully fixing this problem
(other than reinstall), please please reply to this. I'm sure lots of other
people will benefit from it.
Any links to related & useful documentation are also welcomed.
Thanks a lot.
A FuI take it you verified that the Virtual Directories are still setup in IIS?
VDir: reports
Path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager (default)
Default Page: home.aspx
VDir: reportserver
Path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer (default)
There are some other settings of course, if you need I can save the config
to an xml file so you can compare them or import them.
Michael
"A Fu" <A Fu@.discussions.microsoft.com> wrote in message
news:99899F45-632D-4A16-B600-FAFB9B503BC3@.microsoft.com...
> It seems that nobody has detailed knowledge on this issue. I've read other
> postings and found nothing useful. I had no problem accessing report
> manager
> for a long time, and then all of a sudden I get HTTP 404 error OBject Not
> Found. Nothing was changed in IIS, Reports virtual directory, and I'm not
> using SSL.
> If anyone has any actual experience in successfully fixing this problem
> (other than reinstall), please please reply to this. I'm sure lots of
> other
> people will benefit from it.
> Any links to related & useful documentation are also welcomed.
> Thanks a lot.
> A Fu|||Yes, all the paths are set correctly. It seems that the URL virtual path:
"http://www.somesite.com/reports/Pages/Folder.aspx" is wrong. But I have no
problem accessing "http://www.somesite.com/ReportServer".
Is there any other way to upload reports to the RS server, other than thro'
Report Manager & VS.NET?
If you could give me the xml file, that would be great.
Thanks a lot.
"Michael" wrote:
> I take it you verified that the Virtual Directories are still setup in IIS?
> VDir: reports
> Path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager (default)
> Default Page: home.aspx
> VDir: reportserver
> Path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer (default)
> There are some other settings of course, if you need I can save the config
> to an xml file so you can compare them or import them.
> Michael
> "A Fu" <A Fu@.discussions.microsoft.com> wrote in message
> news:99899F45-632D-4A16-B600-FAFB9B503BC3@.microsoft.com...
> > It seems that nobody has detailed knowledge on this issue. I've read other
> > postings and found nothing useful. I had no problem accessing report
> > manager
> > for a long time, and then all of a sudden I get HTTP 404 error OBject Not
> > Found. Nothing was changed in IIS, Reports virtual directory, and I'm not
> > using SSL.
> >
> > If anyone has any actual experience in successfully fixing this problem
> > (other than reinstall), please please reply to this. I'm sure lots of
> > other
> > people will benefit from it.
> >
> > Any links to related & useful documentation are also welcomed.
> >
> > Thanks a lot.
> >
> > A Fu
>
>|||Found the solution to the error 404.
There is a rswebapplication.config file in the reportmanager folder of
reporting services
Change the http://servername/reportserver to
http://servername:8080/reportserver
That's it.
"A Fu" wrote:
> It seems that nobody has detailed knowledge on this issue. I've read other
> postings and found nothing useful. I had no problem accessing report manager
> for a long time, and then all of a sudden I get HTTP 404 error OBject Not
> Found. Nothing was changed in IIS, Reports virtual directory, and I'm not
> using SSL.
> If anyone has any actual experience in successfully fixing this problem
> (other than reinstall), please please reply to this. I'm sure lots of other
> people will benefit from it.
> Any links to related & useful documentation are also welcomed.
> Thanks a lot.
> A Fu
Error 40 : Unable to open connection and Security Issue
When I am using "Windows Integrated Security" to connect to the database from the Report Manager... I am arriving at the "Error:40 Could not open a connection to SQL Server"
Can anyone help me in this issue??
Thanks and regards,
Praveen Kumar Mynamcould you pass few more details.
It is very difficult to predict what is happening at your side and give any solution.
Error 3624 Location: fakerowset.cpp:251
I have the following error when I want to access the design
mode in Entreprise Manager of some tables :
Microsoft SQL-DMO (ODBC SQLState: HY000)
Error: 3624
Expression: accCategory == ACC_CATEGORY_NORMAL || accCatgegory ==
ACC_CATEGORY_BIT
SOPID: 52
Process ID : 2876
I'm running SQL server 2000 with SP3a.
Thanks for your help
You seem to be running into some sort of ASSERT is what I think. Please run
checkdb on your database, and check on the SQL error logs for any stack
dumps. Please paste the input buffer and short stack dump in this thread
and we can analyse.
Also if corruption is the cause, you also want to get your hw vendors
thoroughly involved and have them check your disk, controllers, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Error 3624 Location: fakerowset.cpp:251
I have the following error when I want to access the design
mode in Entreprise Manager of some tables :
Microsoft SQL-DMO (ODBC SQLState: HY000)
Error: 3624
Expression: accCategory == ACC_CATEGORY_NORMAL || accCatgegory == ACC_CATEGORY_BIT
SOPID: 52
Process ID : 2876
I'm running SQL server 2000 with SP3a.
Thanks for your helpYou seem to be running into some sort of ASSERT is what I think. Please run
checkdb on your database, and check on the SQL error logs for any stack
dumps. Please paste the input buffer and short stack dump in this thread
and we can analyse.
Also if corruption is the cause, you also want to get your hw vendors
thoroughly involved and have them check your disk, controllers, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Sunday, February 26, 2012
error 340
message ''Microsoft SQL-DMO error 340:General error'', i can press OK.
Enterprise is launched but there are no Registered servers. when I go and try
and register a new one this message appears ''Server registration information
cannot be changed on remote registries'.
what is happening and what is the fix.
tgarfitt wrote:
> When I open up SQL Enterprise Manager (SQL 7) I get the following
> error message ''Microsoft SQL-DMO error 340:General error'', i
> can press OK. Enterprise is launched but there are no Registered
> servers. when I go and try and register a new one this message
> appears ''Server registration information cannot be changed on remote
> registries'.
> what is happening and what is the fix.
See if this helps:
http://support.microsoft.com/default...26&Product=sql
David Gugick
Quest Software
www.imceda.com
www.quest.com
Sunday, February 19, 2012
Error 229: Permissions problem with sysobjects and sysindexes
I'm trying to view a database using Enterprise Manager and am getting the
following error when I try to view the list of tables, stored procs etc:
Error 229: SELECT permission denied on object 'sysobjects', database
'tours180805', owner 'dbo'.
SELECT permission denied on object 'sysindexes', database 'tours180805',
owner 'dbo'.
I'm not actually the administrator of this database, and all I know is that
it's a snapshot of a live database setup for me to develop against while i'm
writing a B2B link. As such I don't know what method was used to make the
copy, and if anything has been left out during copying. I don't have these
problems when viewing the live version.
Any help gratefully received.
Ben FidgeBen Fidge (BenFidge@.discussions.microsoft.com) writes:
> I'm trying to view a database using Enterprise Manager and am getting the
> following error when I try to view the list of tables, stored procs etc:
> Error 229: SELECT permission denied on object 'sysobjects', database
> 'tours180805', owner 'dbo'.
> SELECT permission denied on object 'sysindexes', database 'tours180805',
> owner 'dbo'.
> I'm not actually the administrator of this database, and all I know is
> that it's a snapshot of a live database setup for me to develop against
> while i'm writing a B2B link. As such I don't know what method was used
> to make the copy, and if anything has been left out during copying. I
> don't have these problems when viewing the live version.
It appears that someone though it a good idea to revoke access for public
to the system tables. You need to see an admin that can address this.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I am a SQL Server DBA (albeit a rookie) and I had the same problem when
moving a database from one server to another (same SQL level and such).
I raked my brain trying to figure out why my customer could not see
the contents of the database when all indications were that the user
IDs were migrated properly from the old to the new server (did I say
"migrated?" yes, user ids were migrated after generating the ddl using
sp_help_revlogin and making sure that all the permissions for the given
user appear to be identical on both servers).
Then I decided to just delete the user and addd it manually to SQL
Server and ... voila! no more 229 error.
Here is what I wonder (would say figured out but I am not that
confident)... When I migrated the user IDs I did so before I migrated
the database, hoping that I would not get any errors during the
database migration that could have been caused by not having a given
user already defined when an object is being created and/or loaded on
the new server. That must have been the cause of the problem because I
migrated another database without first migrating the user IDs and that
problem did not occur.
Anyone with a better explanation?
Erland Sommarskog wrote:
> Ben Fidge (BenFidge@.discussions.microsoft.com) writes:
> It appears that someone though it a good idea to revoke access for public
> to the system tables. You need to see an admin that can address this.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp