Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: Error and issues with backup maintenance plan

    No I'm afraid no one ever replied and I still have the issue.

  • RE: Backup failure

    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...

  • RE: Backup failure

    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.

  • RE: Backup failure

    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...

  • RE: Backup failure

    You are the master! I just set up another job with the code you sent, and it worked like a charm!

    Thanks for everything!

  • RE: Backup failure

    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...

  • RE: Backup failure

    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...

  • RE: Backup failure

    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...

  • RE: Backup failure

    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...

  • RE: Backup failure

    I still haven't been able to get these backups working. Is there anyone that has a suggestion??

    Thank you for your time!

  • RE: Backup failure

    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 ...

  • RE: Backup failure

    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...

  • RE: Backup failure

    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...

  • RE: Backup failure

    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...

Viewing 14 posts - 1 through 14 (of 14 total)