Do u mean SQL and Cold Fusion devloper? As Mentioned in ur email(SQL Cold!)

Just in case u plan on doing using scripts.

To Take Backup

BACKUP DATABASE TO DISK = 'C:\yourOldDatabase.bak'

To Restore to new location:

First Use this command to get the logical file...

No u dont need to. What errors are u getting. R u using WITH MOVE option while resoring?

A) <>

B) !=

Both mean NOT EQUAL TO but (B) is not SQL 92 standard (The third version of SQL Server)

Yes u can copy a database from 2000 and restore the backup copy to 2005. when u successfully restore the copy there in 2005 SQL Server will automatically convert database...

That was really funny:laugh:

So ur talking about SQL Server Agent Services, or Sql Server engine. Just to confirm. The four places where u can look for or atleast four places I look...

Do all system administrators use same user name or different ? If different then u can catch them in event viewer where it will tell u which login stopped services.

May be u dont have proper permission to access the database or the database might be in suspect mode or offline. Can u log into the server using ur credentials?

I think I relied ur question, maybe i was not clear enough.

xintanaka

Q1)

Can anyone tell me if can really detach this large db and create a new Log file using...

even if u dont see anything even on sp_who2 u should take following into consideration. close ur enterprise manager or if ur Database is highlited since u touched it then...

Transaction log holds all your transactions since last time the checkpoint was issued. These are all the queries u executed on that database. so in case of crash u will...

Have u saved ur DTS before converting it to SSIS? I am just asking because all DTS can't be converted to SSIS or some of them give lot of problem....

can u log into Management studio using your SQL credentials using SQL server authentication?

If the stored proc is degrading over time, can u then just recompile it using sp_recompile and then check the results. There must be lot of chsnge in data in...