Hello,

Thank you very much for providing the information.

Restoration got failed.

able to see the error below in restore window. Leave the database ready to use by rolling back uncommited transactions.Additional transactional...

Thank you so much. I am not cancelling it. Luckily the status showing 3%. I am saved. 🙂

But what could be the reason for that much slow ness?

2 weeks back...

Now i can not shrink the log of the source db and take backup again.

I am restoring the backup which i have taken 1 week before. Now i do not...

Log file size is 238 gb.

So shall i stop the restoration?

Hi Ed B,

Thanks Allot. As per your suggestion it worked with command.

Somehow I missed the small logic to try with command. 🙂

Hi,

Thanks for your reply.

What about uncommited transactions during the backup? Still update query is running but not yet commited. But backup is done. In this case how the process will...

I am able to send alert notification with below help

https://www.mssqltips.com/sqlservertip/1859/monitoring-sql-server-database-mirroring-with-email-alerts/

Its resolved. i uninstalled SMMS 18 version and installed old 17 version. then SSIS is connecting.

Its half resolved. The logs growing coz the DR node was down. we brought dr node up. and resumed the database sync in alwayson. but its damn slow.. any suggestion?

i...

log_reuse_wait_desc= Availability_replica

Sorry. The db is in AG setup.

Thanks allot. Around 2 hrs i wasted my time on this. i missed this logic.. Yes i removed the dbs from t-log backup job then added the dbs in alwayson....

Thanks Sue.

Sure. once we configure the Basic Always on configuration in Standard edition can i apply license of the enterprise edition later on for SQL Server? Then we can add...

Thank you very much.. How many databases we can add in the Standard Allwayson group?

I see only one db can be added in the standard edition. What if we want...

Ok. Thanks for replying.