SQL Maintenance job - Manual run/Scheduled run

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Maintenance job - Manual run/Scheduled...

SQL Maintenance job - Manual run/Scheduled run

Rate Topic

Display Mode

Topic Options

Author

Message

Renuka__

Posted Wednesday, October 03, 2012 9:46 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 20, 2013 5:22 AM
Points: 966, Visits: 1,251

Hi All,

We have a weekly full backup job, daily differential backup job and hourly transaction log backup on our servers. These jobs are run through bespoke scripts written (not through regular SQL maintenance plans).
During the week, we often get requests from developere for latest full backup of the databases. Whenever we get such requests, we manually take the full backup of database 'WITH COPY_ONLY' option so that the differential backup chain is not broken.

However, is there any way to amend our scripts in such a way that - whenever the job runs through 'schedule' it should run normally; but if not through schedule ( if initiated manually) then it should take copyonly backup. Is there anyway to check who is running the job ( SQLagent schedule or anyother) dynamically and go to the appropriate step.

We are just trying to avoid to create an additional job for copyonly backups to run whenever a developer's request comes....

Thank you

Renuka__

Post #1367811

naga.rohitkumar

Posted Wednesday, January 30, 2013 1:41 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:45 AM
Points: 525, Visits: 1,005

Hi
iam not good at coding but i can suggest a logic

1.create a script through a maintenance plan if it not runs normally

2.goes full backup copy-only

also search for the scripts options in this site may be any needful there

and i am not so good iam a starter if my suggestion is not correct
reply with the correct answer to me any how you will find soon

i too want the solution now for this issue

Thanks & Regards
NAGA.ROHITKUMAR

Post #1413511

Renuka__

Posted Thursday, January 31, 2013 5:39 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 20, 2013 5:22 AM
Points: 966, Visits: 1,251

Hi,

Thanks for your reply. We created a seperate SQL job that takes COPYONLY backups. We run this job (or particular step for specified database) whenever there is a request from developer.

Thank you
Renuka__

Renuka__

Post #1414025

naga.rohitkumar

Posted Thursday, February 07, 2013 4:07 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:45 AM
Points: 525, Visits: 1,005

Hi, Renuka
can u say how u created the job which takes only copy-only backups even i want to know the process.

Thanks & Regards
NAGA.ROHITKUMAR

Post #1416944

« Prev Topic | Next Topic »

Permissions