.. I know it's pretty old post..

Did the above solution work for anyone else here ?

Asked since we are facing this issue on one of the remote server which is...

Taking full backups do not truncate the logs, log backup does. I have faced this issue sometime back and log backups at appropriate intervals resolved the issue as well. You...

A part of the log will also be backed up at the end of the backup process which helps SQL server to rollback or roll forward. Why should you worry...

.. That shouldn't make any difference I think.

Doesn't matter how you install... installation should succeed.

In our datawarehousing environment, every morning indexes are dropped and then data is loaded into the database and finally the indexes are recreated(which were dropped prior to the loads).

So,...

.. Was blind... din't notice "datawarehousing" environment. Thanks Gila.

jshurak (10/1/2012)

---

Yes, The database is a principal in mirroring. The mirroring session had actually been suspended for a few days (oops), transactions were being hung up in in...

You can also utilize the index related DMVs to decide on which all index to create/keep or which all to remove.

(based on read/write ratio etc; ). As mentioned above, indexes...

Thanks Kraig for the explanation..

.. I was under the impression that she right clicked on the job under SQL Agent and executed it manually...

... Just curious..

Can you login with the service account of SQL Agent and execute the job manually and see if it works ?.

If it works, think changing the schedule time...

Any other process runs at that time ?

How many records are fetched from oracle approx. ?

What about linked server settings ? Check the security tab in linked server properties and...

Evil Kraig F (9/27/2012)

---

vandana_j79 (9/26/2012)

---

I have setup job which run ssis package. In this job i pick data from oracle server with link server. When i run job manually it...

Check the error log.

I suspect the login rights. Check the rights of service account for SQL Server Agent.

Thanks for the response.

Since you posted this to the SQL Server 2005 section, I am guessing that you are trying to restore a 2008 backup on to a 2005 server,...

Thanks Jeff.

Keeping at remote locations and securing with password are the only options ?

Thanks again.

San