Nice info. But I am worried whether this is authenticated one

-MJ

Could you please elaborate on your following comment

"There is one more factor to be considered, from the end of the page starts the row numbering in reverse direction. "

-MJ

The clustered Key is the primary key only. One of the column is Ticketid and other two columns as per my previous post.

I have executed SELECT TOP 1* FROM TicketActivity...

Thanks. I shall take the log backup for complete DB and apply the same in case of any failure. You are quite correct as when the DB is used as...

Thanks all. The info give by John is really useful.

-MJ

Page life expectancy counter value is 1:40. I don't understand how this value would be 750 or 5K. This is the duration when a page can remain in buffer pool...

I have two questions now:

The server has 32 GB RAM. The sql server memory = 32766 MB. (I checked this in the property of the sql server)

Now when I run...

Use ssis. You can use BI also to make the things easy for you.

-MJ

Yes this is shared. But my concern is the only behaviour of Operating system. Why should this read the file when we are taking backups. I would not have raised...

Yes. This error occurs temporarily.

I want to understand that when backup would only save the file then why the OS is trying to open the file. Perhaps I am missing...

Object Type trace event column gives you information that the value was user defined table. This was a temporary table which is lost once you ended the session.

-Michael

According to my knowledge, Sql server logs the transactions files where there is enough space. So according to me you are safe.

-Michael

MANY Thanks for your response. My local drive (H drive) is full. I want to detach this DB and put this in I drive. I tried to put the server...

I think my straight question should be:

If my servername <> my m\c name. Then how to change my server name = my m\c name. There is only one named instance.

-M

The result of the code is as follows:

116400140tempdevT:\MSSQL.1\MSSQL\DATA\tempdev.mdf

316400134tempdev1T:\MSSQL.1\MSSQL\DATA\tempdb1.ndf

416400123tempdev2T:\MSSQL.1\MSSQL\DATA\tempdb2.ndf

516400119tempdev3T:\MSSQL.1\MSSQL\DATA\tempdb3.ndf

616400134tempdev4T:\MSSQL.1\MSSQL\DATA\tempdb4.ndf

716400126tempdev5T:\MSSQL.1\MSSQL\DATA\tempdb5.ndf

816400115tempdev6T:\MSSQL.1\MSSQL\DATA\tempdb6.ndf

916400125tempdev7T:\MSSQL.1\MSSQL\DATA\tempdb7.ndf

1016400102tempdev8T:\MSSQL.1\MSSQL\DATA\tempdb8.ndf

1116400119tempdev9T:\MSSQL.1\MSSQL\DATA\tempdb9.ndf

1216400134tempdev10T:\MSSQL.1\MSSQL\DATA\tempdb10.ndf

1316400119tempdev11T:\MSSQL.1\MSSQL\DATA\tempdb11.ndf

1416400121tempdev12T:\MSSQL.1\MSSQL\DATA\tempdb12.ndf

1516400112tempdev13T:\MSSQL.1\MSSQL\DATA\tempdb13.ndf

1616400115tempdev14T:\MSSQL.1\MSSQL\DATA\tempdb14.ndf

1716400107tempdev15T:\MSSQL.1\MSSQL\DATA\tempdb15.ndf