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...

Would need to use parameters and ensure that your passing an ISO date format through to the query, something like the below, so the user can pass in a start...

Thanks Gail, I will take a read.

running dbcc loginfo gave 32768 results, that I noticed that the log was set to grow in 1MB chunks so thats been changed to 8000MB.

whats the easiest way to reduce...

The database is in simple recovery so no T-Log backups, full backup nightly after the data warehouse load.

There is approx 200GB which is transfered in due to data changes as...

Dumps are a breach of the NDA that you sign prior to completing your exams, any use of dumps is cause for all of your certifications being revoked and not...