Out of space on 6.5 DB

Need to know how to shrink a 6.5 DB. When going inot Shrink dialog it won't let me change it to any amount less thatn what it is already set to.

DBCC won't let me do it bc I have to be in single mode.

Any other options? I know in 7/2K you can:
Backup Database dbname with truncate_only and then restore the bak file.Wow, you're looking for a history lesson here! I'd first try to blow out the log using:
DUMP TRANSACTION myDB WITH TRUNCATE_ONLYYou are correct, SQL 6.5 won't (actually can't) shrink a database unless that database is in single user mode.

-PatP|||I thought that in order to shrink a 6.5 database (device files and all, that is), was to create a new database smaller than the first, and try to import all the data in from the old.|||That's one way, but dumping the log is often enough, and if you can put the database into single user mode you can shrink them. In some ways, 6.5 would allow you to do things that 2000 can't do because the 6.5 device manager is so much "simpler minded" that it can do things that aren't possible in a more sophisticated environment.

-PatP

Out of disk space

We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas?
Thanks
Richard
What is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
|||What is the size of the log file?
"Richard Douglass" wrote:

> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
>

Out of disk space

What is the impact to SQL Server 2000 (sp1) databases should the disk
run out of space?It depends on whether there is free space in the database files or not. If the database files are
full and cannot autogrow, you get below errors when more space is needed to accommodate your
modifications:
1105 for data files
9002 for log files
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"danielp" <danielsmith611@.gmail.com> wrote in message
news:1163694924.709204.294940@.e3g2000cwe.googlegroups.com...
> What is the impact to SQL Server 2000 (sp1) databases should the disk
> run out of space?
>

Out of disk space

We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
--
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>

Out of disk space

What is the impact to SQL Server 2000 (sp1) databases should the disk
run out of space?It depends on whether there is free space in the database files or not. If t
he database files are
full and cannot autogrow, you get below errors when more space is needed to
accommodate your
modifications:
1105 for data files
9002 for log files
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"danielp" <danielsmith611@.gmail.com> wrote in message
news:1163694924.709204.294940@.e3g2000cwe.googlegroups.com...
> What is the impact to SQL Server 2000 (sp1) databases should the disk
> run out of space?
>sql

Out of disk space

We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:

> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>

Out of control log file

To all:
I have a database that's about 2.5 GB in size, but the log file has grown to
over 55GB and has eaten up almost all of my drive space. How can I
remove/replace/compress that log file to recover my hard drive space back?
I've tried recreating the log file by running sp_detach_db, creating a new
log file, and then reattaching the db but it fails. Any suggestions are
greatly appreciated. Thanks in advance.
Steve
Steven Johnston wrote:
> To all:
> I have a database that's about 2.5 GB in size, but the log file has
> grown to over 55GB and has eaten up almost all of my drive space. How
> can I remove/replace/compress that log file to recover my hard drive
> space back? I've tried recreating the log file by running
> sp_detach_db, creating a new log file, and then reattaching the db
> but it fails. Any suggestions are greatly appreciated. Thanks in
> advance.
Read BOL about backup of your database. You can only shrink your tx log
if you do a backup (or do a log backup for truncation only). HTH
robert
|||Have a look here:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations
http://www.nigelrivett.net/Transacti...leGrows_1.html Log File issues
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL Server
2000 with DBCC SHRINKFILE
http://www.support.microsoft.com/?id=873235 How to stop the log file from
growing
http://www.support.microsoft.com/?id=305635 Timeout while DB expanding
http://www.support.microsoft.com/?id=307487 Shrinking TempDB
Andrew J. Kelly SQL MVP
"Steven Johnston" <saj3@.jasper.he.net> wrote in message
news:%23BT4PoUOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> To all:
> I have a database that's about 2.5 GB in size, but the log file has grown
> to over 55GB and has eaten up almost all of my drive space. How can I
> remove/replace/compress that log file to recover my hard drive space back?
> I've tried recreating the log file by running sp_detach_db, creating a new
> log file, and then reattaching the db but it fails. Any suggestions are
> greatly appreciated. Thanks in advance.
> Steve
>

Out of control log file

To all:
I have a database that's about 2.5 GB in size, but the log file has grown to
over 55GB and has eaten up almost all of my drive space. How can I
remove/replace/compress that log file to recover my hard drive space back?
I've tried recreating the log file by running sp_detach_db, creating a new
log file, and then reattaching the db but it fails. Any suggestions are
greatly appreciated. Thanks in advance.
SteveSteven Johnston wrote:
> To all:
> I have a database that's about 2.5 GB in size, but the log file has
> grown to over 55GB and has eaten up almost all of my drive space. How
> can I remove/replace/compress that log file to recover my hard drive
> space back? I've tried recreating the log file by running
> sp_detach_db, creating a new log file, and then reattaching the db
> but it fails. Any suggestions are greatly appreciated. Thanks in
> advance.
Read BOL about backup of your database. You can only shrink your tx log
if you do a backup (or do a log backup for truncation only). HTH
robert|||Have a look here:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations
http://www.nigelrivett.net/Transact...ileGrows_1.html Log File issues
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL Server
2000 with DBCC SHRINKFILE
http://www.support.microsoft.com/?id=873235 How to stop the log file from
growing
http://www.support.microsoft.com/?id=305635 Timeout while DB expanding
http://www.support.microsoft.com/?id=307487 Shrinking TempDB
Andrew J. Kelly SQL MVP
"Steven Johnston" <saj3@.jasper.he.net> wrote in message
news:%23BT4PoUOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> To all:
> I have a database that's about 2.5 GB in size, but the log file has grown
> to over 55GB and has eaten up almost all of my drive space. How can I
> remove/replace/compress that log file to recover my hard drive space back?
> I've tried recreating the log file by running sp_detach_db, creating a new
> log file, and then reattaching the db but it fails. Any suggestions are
> greatly appreciated. Thanks in advance.
> Steve
>

Out of control log file

To all:
I have a database that's about 2.5 GB in size, but the log file has grown to
over 55GB and has eaten up almost all of my drive space. How can I
remove/replace/compress that log file to recover my hard drive space back?
I've tried recreating the log file by running sp_detach_db, creating a new
log file, and then reattaching the db but it fails. Any suggestions are
greatly appreciated. Thanks in advance.
SteveSteven Johnston wrote:
> To all:
> I have a database that's about 2.5 GB in size, but the log file has
> grown to over 55GB and has eaten up almost all of my drive space. How
> can I remove/replace/compress that log file to recover my hard drive
> space back? I've tried recreating the log file by running
> sp_detach_db, creating a new log file, and then reattaching the db
> but it fails. Any suggestions are greatly appreciated. Thanks in
> advance.
Read BOL about backup of your database. You can only shrink your tx log
if you do a backup (or do a log backup for truncation only). HTH
robert|||Have a look here:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations
http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File issues
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL Server
2000 with DBCC SHRINKFILE
http://www.support.microsoft.com/?id=873235 How to stop the log file from
growing
http://www.support.microsoft.com/?id=305635 Timeout while DB expanding
http://www.support.microsoft.com/?id=307487 Shrinking TempDB
--
Andrew J. Kelly SQL MVP
"Steven Johnston" <saj3@.jasper.he.net> wrote in message
news:%23BT4PoUOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> To all:
> I have a database that's about 2.5 GB in size, but the log file has grown
> to over 55GB and has eaten up almost all of my drive space. How can I
> remove/replace/compress that log file to recover my hard drive space back?
> I've tried recreating the log file by running sp_detach_db, creating a new
> log file, and then reattaching the db but it fails. Any suggestions are
> greatly appreciated. Thanks in advance.
> Steve
>sql