Viewing 14 posts - 1 through 14 (of 14 total)
No I'm afraid no one ever replied and I still have the issue.
August 8, 2011 at 2:15 pm
I think Pradeep gave me the code to run the log backups:
declare @log_name as varchar(50)
set @log_name='C:\Backup\test_log_' + convert(varchar,getdate(),112) + '.bak'
backup log test to disk=@log_name
Now that you mention I guess I'm...
November 5, 2009 at 1:13 pm
Thanks, I guess I almost had it. I never would have gotten the end code right.
Thanks again for all your help. It is immensely appreciated.
November 5, 2009 at 9:26 am
Thanks for letting me know. I'll be sure to clear them out once a week. One more question, if I wanted to also set up differential backups, would...
November 5, 2009 at 9:16 am
You are the master! I just set up another job with the code you sent, and it worked like a charm!
Thanks for everything!
November 5, 2009 at 8:54 am
IT WORKED!!! Now that I have a job, I can at least set a regular schedule. I can't understand why the maintenance plan keeps failing.
Can you please tell...
November 5, 2009 at 8:43 am
Thank you for your patience and instructions. I was able to create the job as you stated, but it failed. I just called the job "test1", here's the...
November 5, 2009 at 8:27 am
I'm sorry - I'm not sure how to do that. From the toolbox, do I choose "Execute SQL Server Agent Job Task"? I can't seem to paste the...
November 5, 2009 at 8:07 am
If I choose the "backup database task" instead of using the wizard, I still get the same failure. The only way I am able to back anything in this...
November 5, 2009 at 7:25 am
I still haven't been able to get these backups working. Is there anyone that has a suggestion??
Thank you for your time!
November 4, 2009 at 7:36 am
Here's the T-SQL code from the maintenance plan I set up to run a full backup of a single database, which still fails:
EXECUTE master.dbo.xp_create_subdir N'G:\SQL_backs\psc_comp' GO
BACKUP DATABASE [psc_comp] TO ...
October 20, 2009 at 7:10 am
All databases are in full recovery method. I tried scheduling a full backup of just a single database and it still failed. I also tried to manually run it...
October 19, 2009 at 3:37 pm
Yes, I'm backing up to a local disk. Initially I was trying to backup across our network to another server but switched it to backup to the same hard...
October 16, 2009 at 8:28 am
I ran it by right clicking and choosing execute and I get the same error. I did open the detail and do see some additional information:
"Unable to start execution...
October 16, 2009 at 7:07 am
Viewing 14 posts - 1 through 14 (of 14 total)