Error 1813 while attaching database

I ran out of space, detacted the .mdf and deleted
the .ldf, as I have done in the past. However, when I try
to attach the database I get "Error 1813: Could not open
the new database ... Device activation error. The
physical file name {OLD_LDF_FILE_NAME} may be incorrect."
In the past, it has created a new .ldf file. How can I
get the date out of the mdf? Attach, export, import?Never never never do this, you have just found out why. Grab your backup and do restore, quite
simply. If you don't have a backup, open a case with MS support and they *might* be able to help
you.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Matt Insko" <minsko@.inovie.com> wrote in message news:1afa01c39f3e$6c148a20$3101280a@.phx.gbl...
> I ran out of space, detacted the .mdf and deleted
> the .ldf, as I have done in the past. However, when I try
> to attach the database I get "Error 1813: Could not open
> the new database ... Device activation error. The
> physical file name {OLD_LDF_FILE_NAME} may be incorrect."
> In the past, it has created a new .ldf file. How can I
> get the date out of the mdf? Attach, export, import?|||I've had that problem in the past, and it was because I had truncated
the log at some point, and never done a full backup since. Doing so
meant I could not re-attach the database but had to restore from a
backup.
Since you're out of space, is there any chance you tried to truncate the
log first?
Doug

error 1105 & 9002

Hi ,
For these 2 error 1105 & 9002 , at what stage will it start to raise the
alert ?
when there's no more disk space or it left for example 200M or 10% ? if
there's a field to be set for the alert to me prompted where can i set it ?
appreciate ur advise
tks & rdgs
Message posted via http://www.droptable.comWhen space is needed for a modification and no space is available. They do n
ot fire in advance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim via droptable.com" <u14644@.uwe> wrote in message news:5fad88d638fcb@.uwe...eagreen">
> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it
?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com|||Hi
If you want to manage the database size or disc space usage you can add
alerts in Perfmon or use a product such as MOM to monitor the system.
John
"maxzsim via droptable.com" wrote:

> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it
?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com
>|||tks so much for ur info ppl appreciate it
John Bell wrote:[vbcol=seagreen]
>Hi
>If you want to manage the database size or disc space usage you can add
>alerts in Perfmon or use a product such as MOM to monitor the system.
>John
>
>[quoted text clipped - 7 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1

error 1105 & 9002

Hi ,
For these 2 error 1105 & 9002 , at what stage will it start to raise the
alert ?
when there's no more disk space or it left for example 200M or 10% ? if
there's a field to be set for the alert to me prompted where can i set it ?
appreciate ur advise
tks & rdgs
--
Message posted via http://www.sqlmonster.comWhen space is needed for a modification and no space is available. They do not fire in advance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim via SQLMonster.com" <u14644@.uwe> wrote in message news:5fad88d638fcb@.uwe...
> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com|||Hi
If you want to manage the database size or disc space usage you can add
alerts in Perfmon or use a product such as MOM to monitor the system.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com
>|||tks so much for ur info ppl appreciate it
John Bell wrote:
>Hi
>If you want to manage the database size or disc space usage you can add
>alerts in Perfmon or use a product such as MOM to monitor the system.
>John
>> Hi ,
>[quoted text clipped - 7 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1

Error 1105

Following is the error message that we get when we try to
do some process:
Error No:1105
==========
Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.
I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>
|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
to
id:3)'
additional
>
>.
>
|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>
|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx.gbl...[color=darkblue]
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> programmatically' but, as the
> autogrow. This will
> you have available
> better to anticipate
> message
> to
> id:3)'
> additional

Error 1105

Following is the error message that we get when we try to
do some process:
Error No:1105
========== Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
>> Following is the error message that we get when we try
to
>> do some process:
>> Error No:1105
>> ==========>> Could not allocate space for object '(System table
id:3)'
>> in database 'database name' because primary filegroup is
>> full.
>> sometimes we do get error like the one following:
>> Could not allocate new page for database 'database
>> name'.There are no more pages available in filegroup
>> Primary.
>> Space can be created by dropping objects,adding
additional
>> files , or allowing filegrowth.
>> How do I handle this programatically.
>
>.
>|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx.gbl...
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> >--Original Message--
> >I'm not sure exactly what you mean by 'handle
> programmatically' but, as the
> >error message states, you can set your data file to
> autogrow. This will
> >automatically expand the data file as needed, assuming
> you have available
> >disk space. However, for performance reasons, it is
> better to anticipate
> >space requirements and size the file accordingly.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> >> Following is the error message that we get when we try
> to
> >> do some process:
> >>
> >> Error No:1105
> >> ==========> >> Could not allocate space for object '(System table
> id:3)'
> >> in database 'database name' because primary filegroup is
> >> full.
> >> sometimes we do get error like the one following:
> >> Could not allocate new page for database 'database
> >> name'.There are no more pages available in filegroup
> >> Primary.
> >> Space can be created by dropping objects,adding
> additional
> >> files , or allowing filegrowth.
> >>
> >> How do I handle this programatically.
> >>
> >
> >
> >.
> >

Error 1105

Following is the error message that we get when we try to
do some process:
Error No:1105
==========
Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
> news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
to
id:3)'
additional
>
>.
>|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx
.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========
> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx
.gbl...
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> programmatically' but, as the
> autogrow. This will
> you have available
> better to anticipate
> message
> to
> id:3)'
> additional