As suggested, I just followed your step by step process taking a differential backup and restoring on secondary.

Thank You.

Thanks Guys for your detail step by step guidance.

It worked great. My secondary database is up now.

I was panic, Thanks for all the help.

HI, I already disabled all other backup jobs.

though I have the tran-backup set, I think its all messed up now.

I see only way is to diable the respective jobs...

Thanks for the help

I was using (.) as ".bak" and I removed the dot

Now it works

Thank you.

Thank You.

Thanks you very much,

Is there any way

if the Column 'C' is allowed to have other values than 150 & 151

In That perticular senario both columns A & B can...

Is there anyway I can give the users DDL permissiopns and create a trigger to allow only Admins and dbo's to alter, create & Drop tables any tables ?

If yes...

Sorry Moderator

Its a mistake I reposted this issue.

Sorry for that

Please find the querry execution plan as attachment

Thankyou

If I do

Select * from 'View_Name',

Then its taking more than 3 mins to fetch the result

Actually I will explain in detail.

I have a data base ‘x’.This database ‘x’ has 20 tables.

Among these 20 tables there is one ‘Root Table’ with a Primary key and...

Actually I mean to have a copy of the 3 tables in each database of different instances.

And the content in the tables may or maynot get updated frequently.

In such case...

Actually I would explain in a better way

I have a 'Root' table with 8 columns.

First 5 columns in 'Root table ' are used in all 10 child tables of...