Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

So what do you do if sp_who2 shows nothing

  
   Database Help (Home) -> Full Text RSS
Next:  CRC calculation per record possible? (Continued f..  
Author Message
Van Jump

External


Since: Dec 31, 2008
Posts: 1



(Msg. 1) Posted: Wed Dec 31, 2008 1:19 pm
Post subject: So what do you do if sp_who2 shows nothing
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
I have a database that has been in restore mode for at least three days. sp_who2 shows nothing related to restore or that database. How do I go about fixing this? I'm running in a cluster have shut both servers down stopped and started sql and database remains in restore mode. None of the options in tasks ( offline restore ) either work or appear to be what I want.) Basically I need to stop the restore delete the database and start restore over.

This is a test database on a production server so I'm a bit leary of delete and there is an 83 GB transaction file sitting there for this that I really don't need taking up space

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 >> Stay informed about: So what do you do if sp_who2 shows nothing 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
funny search results with 'contains' clause - hi, it is really funny how ft search works: it seems to depend highly on what could be indexed, but it still doesn't follow a determined order. consider the following queries: select name from person where contains(name, 'hammer') select name from..

Insert Into Without Log - Hi, Can I create an Insert Into Query without sql server registration log? Thx.

SQL 2K : custom word breaker ? - Hi, Is it possible to create a custom word breaker for SQLServer fulltext.... I use french word breaker, but for some specific tables, it's not exactly what I want... Seems such a dream will be feasible in SQL 2K5. Please anyone who knows, tell me the....

restore to another server of db with FT catalogs - If we restore a backup copy of a production db having FT catalogs onto a laptop running SQL Server Developer version, the restored db will contain references to FT catalogs whose underlying system files are not yet present on the laptop (because backup..

fulltext search not working - HI!, Fulltext search is not working, i have two databases, fulltext search functionality was working fine on both of them till now. but suddenly fulltext search on one of the databases started giving out errors. when i try to populate, rebuild was..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]