Means if backup takes two hours and transactions are committed up to last min

like

12 clock backup started and end at 2 clock i will get data up to...

but if we consider

DB - 200GB

for backup it will take 25 min..

suppose 10:45 i started backup of 200GB database

Small Transactions occurring on particular database between 10:45 to 11:05...

Thanks alot ...

Hi,

Same issue on my server also.

cpu-8 and max degree of parallelism is zero

Cost threshold for parallelism is 5

one CXPACKET wait type creating many blocking due to that site is...

USE SSMA for migrating the databases from oracle to MS SQL Server(Any Version)

Use SSMA for migrating oracle databases/schema to MS SQL Server

Try it on Test server.

Sql server Migration Assistant is a free tool from MS SQL Server

Thanks for ur information.

without creating clustered index on filegroup we cant move the table having nonclustered index ?

-------------------------------

code for moving table haing clusterd index

alter table databasename.schema.tablename

drop constraint constraint_name ...