Could you please let us know what was causing the problem? Thanks in advance. 🙂

Thanks for the tip!

Thanks! 😉

Ninja's_RGR'us (10/12/2011)

---

Just a PS, that's why Paul Randal's always does a job to cycle the error logs daily and then keep 99 days.

You can more easily spot what and when...

Leeland (10/12/2011)

---

Sapen (10/12/2011)

---

When I executed the Exec Sp_Cycle_Errorlog a new errorlog was created and I was able to open the errorlog based on the timestamp through sql server error log...

mmady (10/12/2011)

---

I deleted my Linked Server and created one using the following:

sp_addlinkedserver @server = N'CRMCENTRAL',

@srvproduct = N' ',

@provider = N'SQLNCLI',

...

Sapen (10/12/2011)

---

When I executed the Exec Sp_Cycle_Errorlog a new errorlog was created and I was able to open the errorlog based on the timestamp through sql server error log viewer...it...

Another link: http://msdn.microsoft.com/en-us/library/ms188718.aspx

mmady (10/12/2011)

---

The error I am getting is:

I am able to successfully create a linked server connection from the current 2005 env and that does work just fine. I am currently...

Sapen (10/12/2011)

---

Salom,

I was looking into the errorlog file that grew 35GB and all I see is just information messages without any errors and also there were only 26050 records of...

Did you already try restoring the database with a query?

steveb. (10/12/2011)

---

If you have another drive i guess it wouldn't hurt, I think the best practice is to cycle it regulary and setup alerts that will let...

Did you try any of the things mentioned on this link? or here[/url]?

I would like to help, but I have no SQL 7 environtment to run try the linked Server. What kind of error do you get when you try to create...

You can also try to follow the steps on this link