Gail and myself already asked the error logs and application logs.If you give those thing we ll try to help u.

Restarting sql server (or) detach and attach the db will not bring the database online

charipg,

Read my previous replay.

Answer is Yes.

sandhyarao49 (3/24/2010)

---

Hello Experts,

Frequently one of our production server is experiencing high CPU usage, it almost reached 80-90 % at times.

Can anyone let me know from the sql server point of...

Check the system event viewer application error logs.

Nitin Gupta - SQL DBA (3/25/2010)

---

Hi,

If you are sure that, there is no recovery is started from your end and if the environment is not associated with production In such...

Who's responsible for the server ? U.

since...

Read the link

http://www.mssqltips.com/tip.asp?tip=1420

What type of help you need ?

Give me more info...

Manikandan Subramani (3/23/2010)

---

Hi All,

In one of my SQL jobs i am dropping TEXTCATALOG created for a database and while creating the TEXTCATALOG again, i get the error

"sysft_EIS_FullTextCatalog' cannot be...

charipg (3/24/2010)

---

Hi,

Database is in recovery status.

I dont know why it is showing recovery status.

I tried to do detach,offline and drop then every time i am getting error as "The database...

Ur welcome.

Try this

set @Cmd = N'copy "c:\SQLOldFiles\' + @FileName+ '" "c:\SQLNewFiles\"'

Before moving the files

1.take all the current files location

2.take all the DB backups.