Please post your query and the actual full error message you are getting

what anti virus do you have on the server?

we had issues with mcafee and its mass mail worm not allowing to send mail and this was disabled via epo and...

Please take a look at DBCC CHECKDB in BOL or MSDN.

It will basically do consistancy checks to ensure that nothing bad happened due to the error.

it would seem like you lost the E drive (might of been for a short period of time)

do you use a SAN at all, might be worth asking your SAN...

Take a look at utility control point, its more or less the same as MDW but spans multiple servers.

Plenty of information on it in BOL and MSDN.

kranthi.india123 (2/15/2012)

---

Thank You So Much,

Yes..You are saying Absolutely Right.

Please Explain To me clearly(shrinking logshipping DB's),i Got your Point.

can i Shrink the Logshipping DB's??? (what type of impact on Logshipping...

Thanks alot, thats the one, I only did a TOP 1000 and they where all NULL so I skipt over that column.

Much appreciated.

Can you post all the DDL and sample data you have up to now so that we can create a test to help you out, tables, queries so far etc.

Also...

I think the easiest way to think of NT SERVICE\MSSQLSERVER and NT SERVICE\SQLSERVERAGENT is as groups, much like the admin group in computer management.

Bascially, it means that the account running...

kranthi.india123 (2/15/2012)

---

Thank you..SSC eights..

yes..That defiantly Work Load.But I know ..Little Bit confused.

for example every 3 mins Tlog backups are coming Through log shipping.so i haven't check restore job are failure...

you could buy a 3rd party tool which monitors it, or you could write your own WMI Queries to get OS data, wrap it in a powershell script which sends...

coybernardo (2/14/2012)

---

Hello,

We are trying to shrink our database from 2.4TB to 1.5TB to release space on our drives. Most of the data is on one data file. We ran the...

sqlfriends (2/14/2012)

---

We are purchased some sql server R2 license with Software assurance.

Besides free upgrade to next version, I would like to know from other DBA or developers about any other...

kranthi.india123 (2/14/2012)

---

Thank You,

i know.

But little bit confused Again,

can i take Tlog backup of logshipping database through MP(Maintenance plan every 15 mins any impact on logshipping db's)?(Any Mismatch of LSN's)

is Good...

why are you converting the datetime value to a varchar and then comparing it to a datetime? leave the data types alone and use formatted ISO date formats to...