Hi jeff

Thanks for replay and actually i had went through links before positing here.

I was more asking about how to troubleshoot like on which page there is corruption is data...

Hi

 

Sorry folks for late reply here . I got busy in something else

So since online options are not avaliable .I am thinking to practice  it op personal desktop/laptop using VM...

Thanks Jeff and Matt for replies and link

But it still doesnt ans my query.If Index are on disk physical structure as last link says so then why does various books...

Well thanks everybody for answer

Allow me to post my side of story so as to tell why i asked this question in first place

.I work in...

Connections are mostly waiting for commands

satnam.singh 44358 (2/3/2015)

---

Does the user on the Primary Server through which SQL Services are executing have proper permissions on the SQL as well as the folder where the copied files...

satnam.singh 44358 (2/4/2015)

---

Are you performing Update Statistics with FULLSCAN?

If yes then have you checked the Data Types of the columns against which you are performing Update Statistics.

Read this post...

r.szasza (1/30/2015)

---

Hello,

Just for a long shot:

Are you absolutely sure that log restores are happening on the secondary server?

Is your 'copy folder' is being populated with new files?

You can check the...

MyDoggieJessie (1/15/2015)

---

anoop.mig29 (1/15/2015)Hi MyDoggieJessie

I have basic question where to execute the code you provided on secondary server ???

does it requires witnesses server to be present ????

I am getting...

MyDoggieJessie (3/1/2012)

---

Doesn't the query I posted above give you the results you are looking for?

I don't believe there is a way to access/schedule the SSRS report that's built in to...

Same filegroup --> primary

doug.brown (6/11/2014)

---

It sounds like the password might have been changed for the user whose credentials are used for the data source. I would start by checking the data source...

eyespi20 (6/24/2014)

---

Here are three links to PowerShell scripts that do this work in various methods. A Google search of "powershell sql server inventory" brings up quite a few links. Do...

tripleAxe (6/19/2014)

---

Hi Anoop,

I've set something like this up a couple of times now. I've set up a Central Management Server on a SQL Server and used that to do...

Grant Fritchey (6/19/2014)

---

If you're going to set this up yourself, then I agree, Central Management Server is the way to go. There's plenty of documentation on that in the Books...