In SQL 6.5, database devices cannot be shrunk. You'll have to back up the
databases, create new smaller devices, drop the original databases, recreate
the databases on the new devices, and load from backup.
MCSE, SQL Server MCT, MVP
Feed Someone for Free Today:
> Thanks a lot , It really works.
> I know that I have made a mistake by expanding a several database
> devices ( including master, msdbdata, msdblog) to quite large size ( each
> 1 G) . I really should not have done that. What can I do to decrease them?
> Your help is highly appreciated.
> > Open a DOS isql command to SQL server and issue:
> > DUMP TRAN tempdb with no_log.
> > > In the process of insert large amount of data to SQL Server6.5, I got
> > > error in
> > > SQL server enterprise manager. I can not edit and open database
> > > because:
> > > "Error 1101: Unable to allocate new page for database 'tempdb'. There
> are no
> > > more
> > > page available on valid allocation pages. Space can be created by
> > > objects,
> > > extending database or dump the log with no_log "
> > > Since I can not edit any database, I do not know how I can extend the
> > > database or
> > > dump the log with no_log.
> > > Please give me some help.
> > > Thanks,
> > > Yibing Li
> > --
> > Ivan Santhumayor
> > Firmwide Database Support
> > Goldman Sachs & Co
> > Note: These are my own views and not that of Goldman Sachs