Used maintenance plan to create log backup which successfully ran previously.

Error Message:

Executed as user:. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft...

I am also getting the same problem. My database got stuck in restoring mode. The above mentioned command also gives out error.

"The database cannot be recovered because the log...

For deleting a job whose maint plan does not exist and returns the error mentioned in the above discussion

Run the below query and identify the job_id of the job which...

Creating SSIS package will work by which the data can be loaded initially. Also by SQL server agent the same package can be scheduled as a job to run for...

Again run DBCC shrinkfile while no open transaction in tempdb worked out.

Thank You so much for your help in this.

Unused space released back to the drive.

First query returns 1 row where as second does not return any.

There was no active transaction in the db. Even then space has not released and remains same.

Any suggestions?

Since it is running in production environment i haven't killed the SPID.

Planning to wait until it completes.

Thank You.

I think i can wait until the current transaction completes.

Thank you all for your response.

This is in production environment. The file system is about to fill. Hence i am planning to shrink it.

Is there any other way than moving to a larger files...

This is in production environment. The file system is about to fill. Hence i am planning to shrink it.

Is there any other way than moving to a larger files...

Other than SSIS you could use linked server to transfer data.

Since you need this on hourly basis i suggest SSIS would be the better option.

Make sure Oracle is installed in...

The software was already staged in the system.

And i am using the same.

Thanks!

Thanks for your information.