Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hspatil31
Posting Yak Master
182 Posts |
 Posted - 2011-11-16 : 06:28:04
|
| Dear Alll,I am getting following error while executing the JOB for taking backup for transaction log.Can anybody please tell me how to solve this issue ?Error:"The job failed. The job was invoked by user DOMAIN\user. The last step to run was step 1 (Step 1)."Thanks and Regard'sHarish Patil |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-16 : 06:42:36
|
| You need to look at wha the error is (this isn't the error).Some things to look atHave you taken a full backup? Is the database in simple mode, does the destination location exist and does the account have permissions on it, does the database exist?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
hspatil31
Posting Yak Master
182 Posts |
Posted - 2011-11-16 : 06:57:44
|
| Hello Friend,Yesterday I have took the FULL DB backup. DB also exist. While executing this job I have checked the location, there file is available means file was creating. But after the job failed that file is deleting from the location.Can you please tell me why this is happening ? Is there any solution for running this job properly ?Thanks and Regard'sHarish Patil |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-11-16 : 07:13:53
|
| Whats the actual error message ???To check the actual message, right click on job and view history .... > go to failed step and on bottom it will show MESSAGE.--------------------------http://connectsql.com/ |
|
|
|
hspatil31
Posting Yak Master
182 Posts |
Posted - 2011-11-16 : 07:29:44
|
| Hello Freind,It's showing following error message,"The job failed. The job was invoked by user DOMAIN\user. The last step to run was step 1 (Step 1)."And when I exapnding this one then i am getting,"The request operation could not me completed due to file system limitations"Is there any way to Shrink file and truncate file ? I got the solution on google but I am not understating how to do this thing and what are the parameter we have to and how to do ?Can you please help me how to do this ? Or any other solution for above error ?Thanks and Regard'sHarish Patil |
|
|
|
|
|
|
Erro while taking transaction log backup.