Yes, now you can go ahead and change the recovery model to simple if the database is stable most of the time. You can retrieve the data you want from...

I think it is better to change the recovery model to Bulk-logged whenever there are bulk inserts which would minimally log the data inserted and also allows you for point...

ooops...I did not realise this before...;) ...thts right...enterprise is only for server systems...check the requirements for SQL 2005 minimum requirements......

Microsoft Windows 2000 Server with Service Pack (SP) 4 or later;...

I dont think it should make any difference but did u go through the link which i have mentioned in the previous post that should resolve your problem and also...

Hi,

Check your firewall settings and ensure that port 1433 is enabled by default.

Which edition of SQL server are you using??

Follow this link which would help you:

http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/

You can also do this way If am correct:

Restore the backup of the database with a different name and stop the point just before the data loss/to the desired point...

Yes, there should be frequent log backups and also use different files for different backups.....

it is always recommended to set the log file value to a size closer to...

Elisabeth Rédei (11/27/2008)

The other common performance issue with tempdb is contention in the allocation pages. This has nothing to do with your IO because the contention will be in...

Yes, it is a wider topic to discuss.....if you have any specific question related to it then we might surely help you..... good luck !!!

hi,

yes this is for better performance..

this link will help you out in moving tempDB database:

http://support.microsoft.com/kb/224071/EN-US/

Please post your code.....so that we can help further.....trace your server it might help you

Well Done !! Congrats !!

Hi ,

Yes, I think it should be in fine. In SQL 2005 when you attach files from 2000, the server automatcally updates your database.

Hi,

I think you are situation is something like this if you are using SQL 2005 or 2008....

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/%5B/u%5D

As Jack said the default trace is a valuable tool for...

Yes, thats right switch the recovery model to full and with enterprise the size of database is unlimited..Yes you should truncate the log once u have done deleting the data....

Or

You...