[font="Verdana"]Hi,

In the meantime, you can try Copy database wizard for the same.

How to use Copy Database Wizard[/url][/font]

Try the link below

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=301902&SiteID=1&pageid=0

[font="Verdana"]Hi,

Can you post the exact error \ screenshot of the error message you are getting while creating main plan??[/font]

[font="Verdana"]Raj,

Welcome to sqlservercentral.com 🙂

You have posted SQL 2000 query under SQL 2005. Can you post the same under SQL Server 7,2000 section.

And clearly provide the details , coz I'm not...

[font="Verdana"]Hi,

What is the error message you are getting while creating maint plan?

I hope you can create main plan and jobs with installing SSIS..

Anyhw you can check the same by checking...

[font="Verdana"]Try the script below

Backup Script with Retention[/url][/font]

[font="Verdana"]Automatic backup plans means you are backing up through maint plan right??

You can delete the main plan it self and then the job also.

[/font]

[font="Verdana"]As said by Deepak , Restoring from backup is the only option to recover the db back. [/font]

[font="Verdana"]Hi,

Try the steps below

*) Provide modify privilege to SQL Service account on the share

*) Take backup to the local drive -- CREATE maint plan to take the backup, schedule this...

[font="Verdana"]I'm not 100% sure about this, but you can try DDL triggers to do this.[/font]

I'm not sure about this, I hope the source servers log file is...

[font="Verdana"]Try the below website

http://www.sqlis.com/[/url][/font]

[font="Verdana"]Hi Rathesh,

If the database size is small then you can take the backup directly to share drive else you can take the backup to the local disk and then copy...

[font="Verdana"]Hi Williams,

*) Make sure SQLService account has modify privilege to the path mentioned

*) Try taking backup using T-SQL code

Try executing the below and check whether its returning any output

EXEC master.dbo.xp_cmdshell...

[font="Verdana"]Moderators,

Could you please lock the thread![/font]