Fail to drop an instance.

Hi all,
Before I dropped an instance from SQL Server 2005, I tried to take it
offline or detach it. The SQL Server 2005 complaint that it is being
used or the database is locked.
I tried these 2 commands:
first command:
use master
go
drop database gem_prod_1_1
It complaint:
Msg 3702, Level 16, State 4, Line 2
Cannot drop database "gem_prod_1_1" because it is currently in use.
or this command:
alter database gem_prod_1_1
set single_user with rollback immediate
It complaint:
Msg 5061, Level 16, State 1, Line 1
ALTER DATABASE failed because a lock could not be placed on database
'gem_prod_1_1'. Try again later.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
How can I drop the gem_prod_1_1 instance from the SQL Server 2005? Any
idea?
Thanks.
HS Phuah
Use Activity Monitor or sys.sysprocesses to check if there are any active
connections to your database. It is also possible that some system process
is blocking your action.
Regards
Pawel Potasinski
Uzytkownik <hsphuah@.usa.com> napisal w wiadomosci
news:1184639710.453585.89490@.22g2000hsm.googlegrou ps.com...
> Hi all,
> Before I dropped an instance from SQL Server 2005, I tried to take it
> offline or detach it. The SQL Server 2005 complaint that it is being
> used or the database is locked.
> I tried these 2 commands:
> first command:
> use master
> go
> drop database gem_prod_1_1
> It complaint:
> Msg 3702, Level 16, State 4, Line 2
> Cannot drop database "gem_prod_1_1" because it is currently in use.
> or this command:
> alter database gem_prod_1_1
> set single_user with rollback immediate
> It complaint:
> Msg 5061, Level 16, State 1, Line 1
> ALTER DATABASE failed because a lock could not be placed on database
> 'gem_prod_1_1'. Try again later.
> Msg 5069, Level 16, State 1, Line 1
> ALTER DATABASE statement failed.
> How can I drop the gem_prod_1_1 instance from the SQL Server 2005? Any
> idea?
> Thanks.
> HS Phuah
>

Fail to drop an instance.

Hi all,
Before I dropped an instance from SQL Server 2005, I tried to take it
offline or detach it. The SQL Server 2005 complaint that it is being
used or the database is locked.
I tried these 2 commands:
first command:
use master
go
drop database gem_prod_1_1
It complaint:
Msg 3702, Level 16, State 4, Line 2
Cannot drop database "gem_prod_1_1" because it is currently in use.
or this command:
alter database gem_prod_1_1
set single_user with rollback immediate
It complaint:
Msg 5061, Level 16, State 1, Line 1
ALTER DATABASE failed because a lock could not be placed on database
'gem_prod_1_1'. Try again later.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
How can I drop the gem_prod_1_1 instance from the SQL Server 2005? Any
idea?
Thanks.
HS PhuahUse Activity Monitor or sys.sysprocesses to check if there are any active
connections to your database. It is also possible that some system process
is blocking your action.
--
Regards
Pawel Potasinski
Uzytkownik <hsphuah@.usa.com> napisal w wiadomosci
news:1184639710.453585.89490@.22g2000hsm.googlegroups.com...
> Hi all,
> Before I dropped an instance from SQL Server 2005, I tried to take it
> offline or detach it. The SQL Server 2005 complaint that it is being
> used or the database is locked.
> I tried these 2 commands:
> first command:
> use master
> go
> drop database gem_prod_1_1
> It complaint:
> Msg 3702, Level 16, State 4, Line 2
> Cannot drop database "gem_prod_1_1" because it is currently in use.
> or this command:
> alter database gem_prod_1_1
> set single_user with rollback immediate
> It complaint:
> Msg 5061, Level 16, State 1, Line 1
> ALTER DATABASE failed because a lock could not be placed on database
> 'gem_prod_1_1'. Try again later.
> Msg 5069, Level 16, State 1, Line 1
> ALTER DATABASE statement failed.
> How can I drop the gem_prod_1_1 instance from the SQL Server 2005? Any
> idea?
> Thanks.
> HS Phuah
>

Fail to drop an instance.

Hi all,
Before I dropped an instance from SQL Server 2005, I tried to take it
offline or detach it. The SQL Server 2005 complaint that it is being
used or the database is locked.
I tried these 2 commands:
first command:
use master
go
drop database gem_prod_1_1
It complaint:
Msg 3702, Level 16, State 4, Line 2
Cannot drop database "gem_prod_1_1" because it is currently in use.
or this command:
alter database gem_prod_1_1
set single_user with rollback immediate
It complaint:
Msg 5061, Level 16, State 1, Line 1
ALTER DATABASE failed because a lock could not be placed on database
'gem_prod_1_1'. Try again later.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
How can I drop the gem_prod_1_1 instance from the SQL Server 2005? Any
idea?
Thanks.
HS PhuahUse Activity Monitor or sys.sysprocesses to check if there are any active
connections to your database. It is also possible that some system process
is blocking your action.
Regards
Pawel Potasinski
Uzytkownik <hsphuah@.usa.com> napisal w wiadomosci
news:1184639710.453585.89490@.22g2000hsm.googlegroups.com...
> Hi all,
> Before I dropped an instance from SQL Server 2005, I tried to take it
> offline or detach it. The SQL Server 2005 complaint that it is being
> used or the database is locked.
> I tried these 2 commands:
> first command:
> use master
> go
> drop database gem_prod_1_1
> It complaint:
> Msg 3702, Level 16, State 4, Line 2
> Cannot drop database "gem_prod_1_1" because it is currently in use.
> or this command:
> alter database gem_prod_1_1
> set single_user with rollback immediate
> It complaint:
> Msg 5061, Level 16, State 1, Line 1
> ALTER DATABASE failed because a lock could not be placed on database
> 'gem_prod_1_1'. Try again later.
> Msg 5069, Level 16, State 1, Line 1
> ALTER DATABASE statement failed.
> How can I drop the gem_prod_1_1 instance from the SQL Server 2005? Any
> idea?
> Thanks.
> HS Phuah
>

Extracting a table from a dbbackup possible?

Hi there,
A poweruser dropped a table in production(don't ask me why he got
authorization to do that!). So I would restore the backup to a new,
temporary db to extract this table. However, the server lacks diskspace
for another 28 Gb db. This will be remedied in the near future, but
right now I have no room to restore this backup. Is there a way to
extract just 1 table from a backupdevice? I could not find anything via
google sofar, so I doubt it; still, anyone has a solution?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!There is no way to extract a single table from a backup. You must restore
the backup first. I am afraid you will need to find the space somewhere to
restore to.
--
Andrew J. Kelly SQL MVP
"hansje" <hansjes@.anonymous.com> wrote in message
news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> A poweruser dropped a table in production(don't ask me why he got
> authorization to do that!). So I would restore the backup to a new,
> temporary db to extract this table. However, the server lacks diskspace
> for another 28 Gb db. This will be remedied in the near future, but
> right now I have no room to restore this backup. Is there a way to
> extract just 1 table from a backupdevice? I could not find anything via
> google sofar, so I doubt it; still, anyone has a solution?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Lumigent Log Explorer can help with this if you have the logs of when the
table was dropped.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"hansje" <hansjes@.anonymous.com> wrote in message
news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> A poweruser dropped a table in production(don't ask me why he got
> authorization to do that!). So I would restore the backup to a new,
> temporary db to extract this table. However, the server lacks diskspace
> for another 28 Gb db. This will be remedied in the near future, but
> right now I have no room to restore this backup. Is there a way to
> extract just 1 table from a backupdevice? I could not find anything via
> google sofar, so I doubt it; still, anyone has a solution?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Good point Ray...
--
Andrew J. Kelly SQL MVP
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:ObdQdfPtDHA.2932@.TK2MSFTNGP11.phx.gbl...
> Lumigent Log Explorer can help with this if you have the logs of when the
> table was dropped.
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "hansje" <hansjes@.anonymous.com> wrote in message
> news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> > Hi there,
> >
> > A poweruser dropped a table in production(don't ask me why he got
> > authorization to do that!). So I would restore the backup to a new,
> > temporary db to extract this table. However, the server lacks diskspace
> > for another 28 Gb db. This will be remedied in the near future, but
> > right now I have no room to restore this backup. Is there a way to
> > extract just 1 table from a backupdevice? I could not find anything via
> > google sofar, so I doubt it; still, anyone has a solution?
> >
> > Tnx,
> >
> > Hans Brouwer
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>|||Yep!, there were problems with undoing DDL commands in regards to tables in
Log Explorer but the latest version is supposed to have fixed that.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:%23lUiIkPtDHA.424@.TK2MSFTNGP11.phx.gbl...
> Good point Ray...
> --
> Andrew J. Kelly SQL MVP
>
> "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> news:ObdQdfPtDHA.2932@.TK2MSFTNGP11.phx.gbl...
> > Lumigent Log Explorer can help with this if you have the logs of when
the
> > table was dropped.
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "hansje" <hansjes@.anonymous.com> wrote in message
> > news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> > > Hi there,
> > >
> > > A poweruser dropped a table in production(don't ask me why he got
> > > authorization to do that!). So I would restore the backup to a new,
> > > temporary db to extract this table. However, the server lacks
diskspace
> > > for another 28 Gb db. This will be remedied in the near future, but
> > > right now I have no room to restore this backup. Is there a way to
> > > extract just 1 table from a backupdevice? I could not find anything
via
> > > google sofar, so I doubt it; still, anyone has a solution?
> > >
> > > Tnx,
> > >
> > > Hans Brouwer
> > >
> > > *** Sent via Developersdex http://www.developersdex.com ***
> > > Don't just participate in USENET...get rewarded for it!
> >
> >
>