Showing posts with label shrink. Show all posts
Showing posts with label shrink. Show all posts

Tuesday, March 27, 2012

Error 8985 cannot locate file xxx in sysfiles

I am attempting to shrink a datafile (I have 2 primary data files) when I
receive this error message 'Error 8985 cannot locate file xxx in sysfiles'.
I have repeatedly verified the data file name and even did a 'cut n paste'
into a query in qa dbcc shrinkfile with the same results. I have no
problem shrinking the second file and the log file through either method.
I even ran dbcc shrinkfile (3, emptyfile) moving all data to the problem
file. After removing the second datafile I created a new second datafile
in the primary filegroup and am in the process of moving the data to the
new file. Hopefully I will be able to remove the problem file afterward.
Although I suspect this will still not work because I will have to use the
logical file name and not the number.
Any help will be greatly appreciated!
Thanks
Message posted via http://www.sqlmonster.com
You did a cut and paste from where? What column of what
query? Generally the error is due to referencing the
physical file name and not the logical file name. It's hard
to tell as you example is using the file id which is fine as
well. Also, make sure you are in the correct database when
getting the logical file name or id and when executing the
shrinkfile. If you are selecting from sysfiles or executing
sp_helpdb to get the name, it applies to the current
database only. If it still fails and you aren't using
fileid, try using that instead. It could be an issue with
the logical file name not following the rules for
identifiers.
-Sue
On Wed, 02 Mar 2005 19:49:01 GMT, "andy williams via
SQLMonster.com" <forum@.SQLMonster.com> wrote:

>I am attempting to shrink a datafile (I have 2 primary data files) when I
>receive this error message 'Error 8985 cannot locate file xxx in sysfiles'.
>I have repeatedly verified the data file name and even did a 'cut n paste'
>into a query in qa dbcc shrinkfile with the same results. I have no
>problem shrinking the second file and the log file through either method.
>I even ran dbcc shrinkfile (3, emptyfile) moving all data to the problem
>file. After removing the second datafile I created a new second datafile
>in the primary filegroup and am in the process of moving the data to the
>new file. Hopefully I will be able to remove the problem file afterward.
>Although I suspect this will still not work because I will have to use the
>logical file name and not the number.
>Any help will be greatly appreciated!
>Thanks

Error 8985 cannot locate file xxx in sysfiles

I am attempting to shrink a datafile (I have 2 primary data files) when I
receive this error message 'Error 8985 cannot locate file xxx in sysfiles'.
I have repeatedly verified the data file name and even did a 'cut n paste'
into a query in qa dbcc shrinkfile with the same results. I have no
problem shrinking the second file and the log file through either method.
I even ran dbcc shrinkfile (3, emptyfile) moving all data to the problem
file. After removing the second datafile I created a new second datafile
in the primary filegroup and am in the process of moving the data to the
new file. Hopefully I will be able to remove the problem file afterward.
Although I suspect this will still not work because I will have to use the
logical file name and not the number.
Any help will be greatly appreciated!
Thanks
Message posted via http://www.droptable.comYou did a cut and paste from where? What column of what
query? Generally the error is due to referencing the
physical file name and not the logical file name. It's hard
to tell as you example is using the file id which is fine as
well. Also, make sure you are in the correct database when
getting the logical file name or id and when executing the
shrinkfile. If you are selecting from sysfiles or executing
sp_helpdb to get the name, it applies to the current
database only. If it still fails and you aren't using
fileid, try using that instead. It could be an issue with
the logical file name not following the rules for
identifiers.
-Sue
On Wed, 02 Mar 2005 19:49:01 GMT, "andy williams via
droptable.com" <forum@.droptable.com> wrote:

>I am attempting to shrink a datafile (I have 2 primary data files) when I
>receive this error message 'Error 8985 cannot locate file xxx in sysfiles'.
>I have repeatedly verified the data file name and even did a 'cut n paste'
>into a query in qa dbcc shrinkfile with the same results. I have no
>problem shrinking the second file and the log file through either method.
>I even ran dbcc shrinkfile (3, emptyfile) moving all data to the problem
>file. After removing the second datafile I created a new second datafile
>in the primary filegroup and am in the process of moving the data to the
>new file. Hopefully I will be able to remove the problem file afterward.
>Although I suspect this will still not work because I will have to use the
>logical file name and not the number.
>Any help will be greatly appreciated!
>Thanks

error 8985

Hi folks,
When I shrink database, the system raise error 8985: Could not locate file 'databasename_dat' in sysfiles.
Does anyone has experience to solve this error...?
thanks
Sjaiful BahriThis typically means that you've had a device (disk drive) go offline. There is rarely any way to recover unless you can either bring the device back online or restore a backup to another disk.

-PatP

Thursday, March 22, 2012

Error 8115 in Enterprise Manager when I want to shrink my attached Database

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
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

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
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

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
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
>

Sunday, February 26, 2012

Error 3140 on SQL Server 2000

When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.
Bin,
How are you trying to shrink this log? What other steps have you taken before trying to shrink? Are you doing this from enterprise manage or through query analyzer?
Please post the exact error message here and someone may be able to assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.
|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Database
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:

> Bin,
> How are you trying to shrink this log? What other steps have you taken before trying to shrink? Are you doing this from enterprise manage or through query analyzer?
> Please post the exact error message here and someone may be able to assist.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Error
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it

Error 3140 on SQL Server 2000

When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.Bin,
How are you trying to shrink this log? What other steps have you taken befor
e trying to shrink? Are you doing this from enterprise manage or through que
ry analyzer?
Please post the exact error message here and someone may be able to assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE
5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Databas
e
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:

> Bin,
> How are you trying to shrink this log? What other steps have you taken bef
ore trying to shrink? Are you doing this from enterprise manage or through q
uery analyzer?
> Please post the exact error message here and someone may be able to assist
.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B6
28FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Erro
r
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it

Error 3140 on SQL Server 2000

When I do shrink trans log file or database error message came out "Error
3140 Could not adjust the space allocation for the file". I search on
Microsoft WEB only show SQL 7.0. Can someone help me please I already
installed SP3 for it.This is a multi-part message in MIME format.
--=_NextPart_000_008A_01C4CCFC.9D0630B0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Bin,
How are you trying to shrink this log? What other steps have you taken =before trying to shrink? Are you doing this from enterprise manage or =through query analyzer? Please post the exact error message here and someone may be able to =assist.
Tunji O
"BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message =news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
When I do shrink trans log file or database error message came out ="Error 3140 Could not adjust the space allocation for the file". I search on Microsoft WEB only show SQL 7.0. Can someone help me please I already installed SP3 for it.
--=_NextPart_000_008A_01C4CCFC.9D0630B0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Bin,
How are you trying to shrink this log? =What other steps have you taken before trying to shrink? Are you doing this from =enterprise manage or through query analyzer?
Please post the exact error message =here and someone may be able to assist.
Tunji O
"BIN YANG" wrote in message news:8B6=28FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...When I do shrink trans log file or database error message came out "Error =3140 Could not adjust the space allocation for the file". I search on =Microsoft WEB only show SQL 7.0. Can someone help me please I already =installed SP3 for it.

--=_NextPart_000_008A_01C4CCFC.9D0630B0--|||I shrink data through SQL Server Enterprise Manager All Tasks Shrink Database
task the error message as follow:
Microsoft SQL-DMO(ODBC SQLSTATE:42000)
Error 3140:Could not adjust the space allocation for the file'truck_data'.
DBCC execution completeed. If DBCC printed error messages, contact your
system administrator.
"Tunji" wrote:
> Bin,
> How are you trying to shrink this log? What other steps have you taken before trying to shrink? Are you doing this from enterprise manage or through query analyzer?
> Please post the exact error message here and someone may be able to assist.
> Tunji O
> "BIN YANG" <BINYANG@.discussions.microsoft.com> wrote in message news:8B628FE5-842E-4A14-9331-2BA683E3F97B@.microsoft.com...
> When I do shrink trans log file or database error message came out "Error
> 3140 Could not adjust the space allocation for the file". I search on
> Microsoft WEB only show SQL 7.0. Can someone help me please I already
> installed SP3 for it