Ok thanks I will try

Got it thanks I will do more research on it

It has 205 Indexes as I said when I do this in Prod it takes 2 hours to reorg and rebuild...

Its just a stand alone server which we do backup every night and restore every night. No Log shipping or mirroring or Always on.

I hope that answer your question

Thanks I will not put column name like count and time going forward.

Sorry for the typo mistake, it should be 300 and not 100.

I insert data every 5 minutes and...

Anyone please help with the code

I have temp table created by application which starts from SST, SSW, DDL and this gets deleted after the process is completed.

Note: for example every...

This is what the error I got

USE [master]

GO

CREATE DATABASE [DBTest] ON

( FILENAME = N'D:\SQL_Data\DBTest.mdf' ),

( FILENAME = N'D:\SQL_Log\DBTest.ldf' )

FOR ATTACH

GO

ERROR Message: (Though I have full access to d drive and...

I am trying to copy MDF and LDF file from one server to another.

Initial On primary the DB was on C drive and on new server I was trying to...

This is not working

Steve thanks a lot it is working after your suggestion

I got your point...Thanks

So basically full restore has to be done  either it's a differential or Tlog.

Thanks once again

Let me phrase again.

My Sunday full backup finished at 6 AM

I have 2 transaction after full backup one at 7 AM and other at 8 AM. I want to just...

Thanks I am able to get my result.

This is how the application has setup date unfortunately

Thanks Once again

Thanks this helped me kind of what I am looking for

Thanks a lot yes this worked as I expected

Table has been insert one row for each table for each date