I think SSMS is best free tool.

Check if Autoclose property for your database is set to True.

If so bring database offline and online to resolve this issue.

If issue still exists, please check the link below, hopefully...

Hi,

we are also facing the same issue, please let us know if you are able fix it.

I had the same issue, but the problem is Instance was not configured after configuring it worked fine.

I hope it would help someone like me who might get this kind...

I would suggest talk to your network admins if you are not aware of how to do it.

Try restarting your netwrok services, I think that sould fix it.

Using appropriate RAID levels will always minimize the chance of data loss, to a great extent. You can serach for RAID levels in google and you will get many articles.

I think it is because, i was trying to restore the backup file on the new server where we don't have lite speed installed, now we have installed and able...

Thanks for the response :-), Yes we are using Lite speed as backup software and it is the cause for the issue. I think we need to speak to Light...

For connection string try this link

http://www.connectionstrings.com/[/url]

for creating users please read BOL

http://msdn.microsoft.com/en-us/library/ms173463.aspx

I have a question regarding the restore. We have weekly full backups and daily differentials, but I don't know when this corruption occurred. So my question is, if...

It all depends on how big is your application and how much load is expected on SQL Server

Images will not help, please read article in my signature, and post as per it people will come up with gr8 solutions for you.

You need add all servers to RegSrvr.xml file which is stored in C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell for SQL 2008 on Windows 2008 and for SQL 2005 it should be in C:\Documents...

Lucky9 (6/14/2010)

---

Help needed....

I have created 6 stored procedures and am calling all the 6 stored procedures within SSIS.

...