Scheduling DtsBackup2000?

Dear folks,
Is it possible? Show us a instatiable model such application? I would like
to develop any which might be able to start and do the wly transferences
to disk (.dts,.dtb).
Thanks for any comment or idea,Hi Enric,
What i do is make a .cmd file that contains all the DTSBackup2000cmd.exe
command lines
I then use SQL Server Agent and scheduled a CmdExec job that executes the
.cmd file nightly
HTH. Ryan
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:D86F5040-3C86-44D9-AB08-1A2370A390F0@.microsoft.com...
> Dear folks,
> Is it possible? Show us a instatiable model such application? I would like
> to develop any which might be able to start and do the wly
> transferences
> to disk (.dts,.dtb).
> Thanks for any comment or idea,
>|||Right. Do you mind show me a few ones?
thanks
"Ryan" wrote:

> Hi Enric,
> What i do is make a .cmd file that contains all the DTSBackup2000cmd.exe
> command lines
> I then use SQL Server Agent and scheduled a CmdExec job that executes the
> ..cmd file nightly
> --
> HTH. Ryan
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:D86F5040-3C86-44D9-AB08-1A2370A390F0@.microsoft.com...
>
>|||Here's how...
Open Notepad paste the following in
DTSBackup2000Cmd.exe /SS (local) /SE /T /DS OffSite /DU sa /DP password
Save AS - DTSBackup.cmd
Then navigate your way to Jobs in EnterPrise Manager and schedule the
running of DTSBackup.cmd
Management\SQL Server Agent\Jobs
Right Click\New Job\Steps\New\Type\CmdExec
HTH. Ryan
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:4A0F1FA2-FB8E-4BF0-AD1C-6697D8163B24@.microsoft.com...
> Right. Do you mind show me a few ones?
> thanks
> "Ryan" wrote:
>|||Thanks a lot Ryan.
"Ryan" wrote:

> Here's how...
> Open Notepad paste the following in
> DTSBackup2000Cmd.exe /SS (local) /SE /T /DS OffSite /DU sa /DP password
> Save AS - DTSBackup.cmd
> Then navigate your way to Jobs in EnterPrise Manager and schedule the
> running of DTSBackup.cmd
> Management\SQL Server Agent\Jobs
> Right Click\New Job\Steps\New\Type\CmdExec
>
> --
> HTH. Ryan
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:4A0F1FA2-FB8E-4BF0-AD1C-6697D8163B24@.microsoft.com...
>
>

Scheduling a java process

This question is more of a java question than a SQL Server question. But
still...
I am working in java; application server is Jboss and database is MS SQL
Server 2000.
I have a process written as an EJB in java. I want to schedule this proces
to run every hour every day. I was thinking about using the SQL Server to
schedule it. Is it possible? If yes then how? Any input is really
appreciated.
ThanksHi
Create a SQL Server agent job, with the job calling the EJB from the command
line. Not the best and cleanest solution, as database servers should not
have a lot of "application" instillations on it. IT should be a pure DB
server with all other processes running on a separate machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rizwan" <hussains@.pendylum.com> wrote in message
news:PMG4e.9963$Fy3.815744@.news20.bellglobal.com...
> This question is more of a java question than a SQL Server question. But
> still...
> I am working in java; application server is Jboss and database is MS SQL
> Server 2000.
> I have a process written as an EJB in java. I want to schedule this proces
> to run every hour every day. I was thinking about using the SQL Server to
> schedule it. Is it possible? If yes then how? Any input is really
> appreciated.
> Thanks
>
>|||How the job can call an EJB from the command line? Can you give an example ?
Thanks
Rizwan
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uosA4rlOFHA.2144@.TK2MSFTNGP09.phx.gbl...
> Hi
> Create a SQL Server agent job, with the job calling the EJB from the
command
> line. Not the best and cleanest solution, as database servers should not
> have a lot of "application" instillations on it. IT should be a pure DB
> server with all other processes running on a separate machine.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rizwan" <hussains@.pendylum.com> wrote in message
> news:PMG4e.9963$Fy3.815744@.news20.bellglobal.com...
proces
to
>

Scheduledefinition.Item returns always null

Hi All,

I have a built an application to manage the report-subscription on my ReportServer.
I'm having some troubles with retrieving the subscription properties.

My problem:
I can retrieve all my propertie except the schedule definition, when I deserialize it, the Sceduledefenition.Item always returns null.

I use the next code to deserialize it:
//////////////////////////////////////////////////////////////////////////////////////////////////////
private XmlAttributeOverrides GetSchedule()
{
XmlAttributeOverrides xmlAttrOverride = new XmlAttributeOverrides();
XmlAttributes XmlAttr = new XmlAttributes();
XmlAttr.Xmlns = false;
xmlAttrOverride.Add(typeof(ScheduleDefinition), XmlAttr);
xmlAttrOverride.Add(typeof(MinuteRecurrence), XmlAttr);
xmlAttrOverride.Add(typeof(DailyRecurrence), XmlAttr);
xmlAttrOverride.Add(typeof(WeeklyRecurrence), XmlAttr);
xmlAttrOverride.Add(typeof(MonthlyRecurrence), XmlAttr);
xmlAttrOverride.Add(typeof(MonthlyDOWRecurrence), XmlAttr);
xmlAttrOverride.Add(typeof(DaysOfWeekSelector), XmlAttr);
xmlAttrOverride.Add(typeof(MonthsOfYearSelector), XmlAttr);
return xmlAttrOverride;
}

private ScheduleDefinition DeserializeScheduleDefenition(string MatchData)
{
XmlAttributeOverrides xmlAttrOverride = GetSchedule();
XmlSerializer ser = new XmlSerializer(typeof(ScheduleDefinition),xmlAttrOverride);
Stream stream = new MemoryStream(System.Text.Encoding.Default.GetBytes(MatchData));
stream.Position = 0;
return (ScheduleDefinition)ser.Deserialize(stream);
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

I'have tried almost everything, but could not find the solution.

Please, this is very important for me, so every tip or shared thought could be very helpfull.

Thnx in advance

I have done some of investigation on this problem again and came up with the next weird thing:

When I create the subscription with my own application everything works well, so the subscription is added to the list in REPORTMANAGER.
when I use my own application to retrieve the properties of the subscription everything goes well also.

But now it comes:
When I update the subscription with my own application, the subscription is updated well also. (I use the SetSubscriptionProperties() method of reportingservices2005)

If I go to the reportmanager to edit my subscription I can see that my function updated the subscription well.

BUT when I retrieve the susbscription properties with my own application I get the Problem I wrote about in the original post.

AND when I edit the susbscription with the reportmanager and I retrieve the properties again, it goes all OK again. AND VICE VERCA If I update it with my OWN application, I get the problem again.

This is very weird for me to understand, am I doing something wrong with the SetSubscriptionProperties() method
OR am I doing something wrong with the GetSubscriptionProperties() method.

Hopefully somebody can help now with this issue.

|||

This posting is about same problem and has some suggestions: http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/e2df8bbce14df692/b9276e2c55fca249

Scheduled job fails when old db's offline

I have a SQL Server 2000 db, that has db's unrelated to an application that
I run some sql server scheduled tasks. I decided I wanted to dump these old
db's, so the first step is to take the db's offline for a week before
deleting them. Well for some reason all tasks for an unrelated (?) system
would fail and until I brought these unconnected db's back online they
wouldn't run.
If I went into dts and run the apps they run fine, the Id is my elevated
domain admin account. The sql server agent that runs the task is a domain
account with local admin privileges.
Is there something I can check for to try and get more info? Nothing in the
sql logs, in the Event logs this is all I get. Stumped?
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 10/9/2007
Time: 11:02:10 AM
User: N/A
Computer: some_SQL
Description:
SQL Server Scheduled Job 'Extract_Command_Center_Meters'
(0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by User
some_domain\some_admin. The last step to run was step 1
(Extract_Command_Center_Meters 2).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.SQL Agent itself doesn't care about what dbs are on or offline. But the job
obviously does so I would start there. Look in the DTS package to see where
it references these databases. You can also try looking at the job step
itself in the job history. You will need to expand the history listing to
see the individual steps.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>I have a SQL Server 2000 db, that has db's unrelated to an application that
>I run some sql server scheduled tasks. I decided I wanted to dump these
>old db's, so the first step is to take the db's offline for a week before
>deleting them. Well for some reason all tasks for an unrelated (?) system
>would fail and until I brought these unconnected db's back online they
>wouldn't run.
> If I went into dts and run the apps they run fine, the Id is my elevated
> domain admin account. The sql server agent that runs the task is a domain
> account with local admin privileges.
> Is there something I can check for to try and get more info? Nothing in
> the sql logs, in the Event logs this is all I get. Stumped?
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 10/9/2007
> Time: 11:02:10 AM
> User: N/A
> Computer: some_SQL
> Description:
> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
> User some_domain\some_admin. The last step to run was step 1
> (Extract_Command_Center_Meters 2).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> --
> Paul Bergson
> MVP - Directory Services
> MCT, MCSE, MCSA, Security+, BS CSci
> 2003, 2000 (Early Achiever), NT
> http://www.pbbergs.com
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Done that already. Dang... I just am truly stumped.
As you notice it will run if done directly from the DTS editor.
--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23VSwWdpCIHA.464@.TK2MSFTNGP02.phx.gbl...
> SQL Agent itself doesn't care about what dbs are on or offline. But the
> job obviously does so I would start there. Look in the DTS package to see
> where it references these databases. You can also try looking at the job
> step itself in the job history. You will need to expand the history
> listing to see the individual steps.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
> news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>>I have a SQL Server 2000 db, that has db's unrelated to an application
>>that I run some sql server scheduled tasks. I decided I wanted to dump
>>these old db's, so the first step is to take the db's offline for a week
>>before deleting them. Well for some reason all tasks for an unrelated (?)
>>system would fail and until I brought these unconnected db's back online
>>they wouldn't run.
>> If I went into dts and run the apps they run fine, the Id is my elevated
>> domain admin account. The sql server agent that runs the task is a
>> domain account with local admin privileges.
>> Is there something I can check for to try and get more info? Nothing in
>> the sql logs, in the Event logs this is all I get. Stumped?
>> Event Type: Warning
>> Event Source: SQLSERVERAGENT
>> Event Category: Job Engine
>> Event ID: 208
>> Date: 10/9/2007
>> Time: 11:02:10 AM
>> User: N/A
>> Computer: some_SQL
>> Description:
>> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
>> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
>> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
>> User some_domain\some_admin. The last step to run was step 1
>> (Extract_Command_Center_Meters 2).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> --
>> Paul Bergson
>> MVP - Directory Services
>> MCT, MCSE, MCSA, Security+, BS CSci
>> 2003, 2000 (Early Achiever), NT
>> http://www.pbbergs.com
>> Please no e-mails, any questions should be posted in the NewsGroup
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>|||I had have the very same problem with a customer, they disabled the user
account which was the owner of the job and they were getting exactly the
same error...
--
Ekrem Önsoy
"Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
news:Oq9f%23fqCIHA.4752@.TK2MSFTNGP04.phx.gbl...
> Done that already. Dang... I just am truly stumped.
> As you notice it will run if done directly from the DTS editor.
> --
> Paul Bergson
> MVP - Directory Services
> MCT, MCSE, MCSA, Security+, BS CSci
> 2003, 2000 (Early Achiever), NT
> http://www.pbbergs.com
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23VSwWdpCIHA.464@.TK2MSFTNGP02.phx.gbl...
>> SQL Agent itself doesn't care about what dbs are on or offline. But the
>> job obviously does so I would start there. Look in the DTS package to see
>> where it references these databases. You can also try looking at the job
>> step itself in the job history. You will need to expand the history
>> listing to see the individual steps.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
>> news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>>I have a SQL Server 2000 db, that has db's unrelated to an application
>>that I run some sql server scheduled tasks. I decided I wanted to dump
>>these old db's, so the first step is to take the db's offline for a week
>>before deleting them. Well for some reason all tasks for an unrelated
>>(?) system would fail and until I brought these unconnected db's back
>>online they wouldn't run.
>> If I went into dts and run the apps they run fine, the Id is my elevated
>> domain admin account. The sql server agent that runs the task is a
>> domain account with local admin privileges.
>> Is there something I can check for to try and get more info? Nothing in
>> the sql logs, in the Event logs this is all I get. Stumped?
>> Event Type: Warning
>> Event Source: SQLSERVERAGENT
>> Event Category: Job Engine
>> Event ID: 208
>> Date: 10/9/2007
>> Time: 11:02:10 AM
>> User: N/A
>> Computer: some_SQL
>> Description:
>> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
>> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
>> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
>> User some_domain\some_admin. The last step to run was step 1
>> (Extract_Command_Center_Meters 2).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> --
>> Paul Bergson
>> MVP - Directory Services
>> MCT, MCSE, MCSA, Security+, BS CSci
>> 2003, 2000 (Early Achiever), NT
>> http://www.pbbergs.com
>> Please no e-mails, any questions should be posted in the NewsGroup
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>

Scheduled backup in SQL Server 2005 Express

SQL Server 2005 Express does not have any possibilities to schedule backup so
I have made a simple application for scheduling backup, running a stored
procedure in my database.
The procedure backup up to the same backup device so all backup sets are
stored in the same file. RETAINDAYS is set to 365.
In the “Restore Database” dialog in SQL Server 2005 Management Studio
Express I can se all backup sets in the backup file and also the ‘Expiration’
date for each backup set.
I thought that setting option INIT and NOSKIP would overwrite expired backup
sets but instead I get an error message “the medium on device <device>
expires on <date> and cannot be overwritten.
I though that new backup sets would be appended until a backup set expires
but it does not look like that.
Any suggestion on how to preserve backup sets for some days and then
overwrite it?
Help is appreciated.
Regards Kjell Arne Johansen
Hi
What I would do If I were you :-))))) just create .BAK file with GEDDATE()
contacinated , so later on you can delete those files based on file name.
"Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
> SQL Server 2005 Express does not have any possibilities to schedule backup
> so
> I have made a simple application for scheduling backup, running a stored
> procedure in my database.
> The procedure backup up to the same backup device so all backup sets are
> stored in the same file. RETAINDAYS is set to 365.
> In the Restore Database dialog in SQL Server 2005 Management Studio
> Express I can se all backup sets in the backup file and also the
> Expiration
> date for each backup set.
> I thought that setting option INIT and NOSKIP would overwrite expired
> backup
> sets but instead I get an error message the medium on device <device>
> expires on <date> and cannot be overwritten.
> I though that new backup sets would be appended until a backup set expires
> but it does not look like that.
> Any suggestion on how to preserve backup sets for some days and then
> overwrite it?
> Help is appreciated.
> Regards Kjell Arne Johansen
>
|||Hi
Yes I have an option to create backup with unique filenames also but I want
to know if there is anything I can use in SQL Server to do this for me and if
INIT and NOSKIP or other options can be used.
Kjell Arne
"Uri Dimant" wrote:

> Hi
> What I would do If I were you :-))))) just create .BAK file with GEDDATE()
> contacinated , so later on you can delete those files based on file name.
>
>
> "Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
> message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
>
>

Scheduled backup in SQL Server 2005 Express

SQL Server 2005 Express does not have any possibilities to schedule backup s
o
I have made a simple application for scheduling backup, running a stored
procedure in my database.
The procedure backup up to the same backup device so all backup sets are
stored in the same file. RETAINDAYS is set to 365.
In the “Restore Database” dialog in SQL Server 2005 Management Studio
Express I can se all backup sets in the backup file and also the ‘Expirati
on’
date for each backup set.
I thought that setting option INIT and NOSKIP would overwrite expired backup
sets but instead I get an error message “the medium on device <device>
expires on <date> and cannot be overwritten.
I though that new backup sets would be appended until a backup set expires
but it does not look like that.
Any suggestion on how to preserve backup sets for some days and then
overwrite it?
Help is appreciated.
Regards Kjell Arne JohansenHi
What I would do If I were you :-))))) just create .BAK file with GEDDATE()
contacinated , so later on you can delete those files based on file name.
"Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
> SQL Server 2005 Express does not have any possibilities to schedule backup
> so
> I have made a simple application for scheduling backup, running a stored
> procedure in my database.
> The procedure backup up to the same backup device so all backup sets are
> stored in the same file. RETAINDAYS is set to 365.
> In the Restore Database dialog in SQL Server 2005 Management Studio
> Express I can se all backup sets in the backup file and also the
> Expiration
> date for each backup set.
> I thought that setting option INIT and NOSKIP would overwrite expired
> backup
> sets but instead I get an error message the medium on device <device>
> expires on <date> and cannot be overwritten.
> I though that new backup sets would be appended until a backup set expires
> but it does not look like that.
> Any suggestion on how to preserve backup sets for some days and then
> overwrite it?
> Help is appreciated.
> Regards Kjell Arne Johansen
>|||Hi
Yes I have an option to create backup with unique filenames also but I want
to know if there is anything I can use in SQL Server to do this for me and i
f
INIT and NOSKIP or other options can be used.
Kjell Arne
"Uri Dimant" wrote:

> Hi
> What I would do If I were you :-))))) just create .BAK file with GEDDATE()
> contacinated , so later on you can delete those files based on file name.
>
>
> "Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote
in
> message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
>
>

Scheduled backup in SQL Server 2005 Express

SQL Server 2005 Express does not have any possibilities to schedule backup so
I have made a simple application for scheduling backup, running a stored
procedure in my database.
The procedure backup up to the same backup device so all backup sets are
stored in the same file. RETAINDAYS is set to 365.
In the â'Restore Databaseâ' dialog in SQL Server 2005 Management Studio
Express I can se all backup sets in the backup file and also the â'Expirationâ'
date for each backup set.
I thought that setting option INIT and NOSKIP would overwrite expired backup
sets but instead I get an error message â'the medium on device <device>
expires on <date> and cannot be overwritten.
I though that new backup sets would be appended until a backup set expires
but it does not look like that.
Any suggestion on how to preserve backup sets for some days and then
overwrite it?
Help is appreciated.
Regards Kjell Arne JohansenHi
What I would do If I were you :-))))) just create .BAK file with GEDDATE()
contacinated , so later on you can delete those files based on file name.
"Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
> SQL Server 2005 Express does not have any possibilities to schedule backup
> so
> I have made a simple application for scheduling backup, running a stored
> procedure in my database.
> The procedure backup up to the same backup device so all backup sets are
> stored in the same file. RETAINDAYS is set to 365.
> In the ?Restore Database? dialog in SQL Server 2005 Management Studio
> Express I can se all backup sets in the backup file and also the
> ?Expiration?
> date for each backup set.
> I thought that setting option INIT and NOSKIP would overwrite expired
> backup
> sets but instead I get an error message ?the medium on device <device>
> expires on <date> and cannot be overwritten.
> I though that new backup sets would be appended until a backup set expires
> but it does not look like that.
> Any suggestion on how to preserve backup sets for some days and then
> overwrite it?
> Help is appreciated.
> Regards Kjell Arne Johansen
>|||Hi
Yes I have an option to create backup with unique filenames also but I want
to know if there is anything I can use in SQL Server to do this for me and if
INIT and NOSKIP or other options can be used.
Kjell Arne
"Uri Dimant" wrote:
> Hi
> What I would do If I were you :-))))) just create .BAK file with GEDDATE()
> contacinated , so later on you can delete those files based on file name.
>
>
> "Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
> message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
> > SQL Server 2005 Express does not have any possibilities to schedule backup
> > so
> > I have made a simple application for scheduling backup, running a stored
> > procedure in my database.
> > The procedure backup up to the same backup device so all backup sets are
> > stored in the same file. RETAINDAYS is set to 365.
> > In the â'Restore Databaseâ' dialog in SQL Server 2005 Management Studio
> > Express I can se all backup sets in the backup file and also the
> > â'Expirationâ'
> > date for each backup set.
> > I thought that setting option INIT and NOSKIP would overwrite expired
> > backup
> > sets but instead I get an error message â'the medium on device <device>
> > expires on <date> and cannot be overwritten.
> > I though that new backup sets would be appended until a backup set expires
> > but it does not look like that.
> > Any suggestion on how to preserve backup sets for some days and then
> > overwrite it?
> >
> > Help is appreciated.
> >
> > Regards Kjell Arne Johansen
> >
>
>

Scheduled Backup for SQL Server Express

Not sure if this is the right forum, so please correct me if I'm in error.
I've written a Timeclock application in VB6 for our small chain of retail
stores and storing the data in a SQL Server Express database. All is
working well, but I want to perform a nighly backup of the database and
there appears to be no Maintenance Plan setup wizard in SQL Server Express.
Can anyone provide me with a query that I can launch at a scheduled time to
perform this or another alternative.
Thank you,
BarryThere is no SQL Server Agent in Express edition of SQL Server 2005, so no
scheduled tasks can be performed using standard tools. You may use OS
scheduler and SQLCMD to do this job or write your own backup app. Or, if
your Express instances can be accessed as linked servers from Standard or
Enterprise instance, you may do so by scheduling remote procedure calls on
this instance.
WBR, Evergray
--
Words mean nothing...
"BCS" <bswedeen@.tayloroil.com> wrote in message
news:NgmJf.21119$no3.16791@.tornado.southeast.rr.com...
> Not sure if this is the right forum, so please correct me if I'm in error.
> I've written a Timeclock application in VB6 for our small chain of retail
> stores and storing the data in a SQL Server Express database. All is
> working well, but I want to perform a nighly backup of the database and
> there appears to be no Maintenance Plan setup wizard in SQL Server
> Express.
> Can anyone provide me with a query that I can launch at a scheduled time
> to
> perform this or another alternative.
> Thank you,
> Barry
>|||The command to do a backup is BACKUP and you can see all the details in
BooksOnLine. But which options you use and the exact syntax depends on
exactly what you want to do and how. You might want to have a look at BOL
under BACKUP to get an idea what you want first to see what is available.
Andrew J. Kelly SQL MVP
"BCS" <bswedeen@.tayloroil.com> wrote in message
news:NgmJf.21119$no3.16791@.tornado.southeast.rr.com...
> Not sure if this is the right forum, so please correct me if I'm in error.
> I've written a Timeclock application in VB6 for our small chain of retail
> stores and storing the data in a SQL Server Express database. All is
> working well, but I want to perform a nighly backup of the database and
> there appears to be no Maintenance Plan setup wizard in SQL Server
> Express.
> Can anyone provide me with a query that I can launch at a scheduled time
> to
> perform this or another alternative.
> Thank you,
> Barry
>|||You could use a combination of SQL statements and Scheduled Tasks:
CREATE PROCEDURE nightlybackup
AS
BACKUP DATABASE [yourdb]
TO DISK = 'c:\backups\dbbackup.dat'
BACKUP LOG [yourdb]
TO DISK = 'c:\backups\dblogbackup.dat'
Now create a cmd script; run the below at a command prompt (all on one line,
of course):
echo osql -d [yourdb] -E -Q "EXEC
dbo.nightlybackup">>c:\backups\nightlybackup.cmd
Now add it as a scheduled task (all on one line again):
schtasks /create /tn nightlybackup /tr c:\backups\nightlybackup.cmd /sc
daily /st 00:05:00
This will do a daily backup at 5 minutes after midnight. Do all of this
logged on as a local administrator.
"BCS" wrote:

> Not sure if this is the right forum, so please correct me if I'm in error.
> I've written a Timeclock application in VB6 for our small chain of retail
> stores and storing the data in a SQL Server Express database. All is
> working well, but I want to perform a nighly backup of the database and
> there appears to be no Maintenance Plan setup wizard in SQL Server Express
.
> Can anyone provide me with a query that I can launch at a scheduled time t
o
> perform this or another alternative.
> Thank you,
> Barry
>
>|||Thanks to everyone for your input.
Barry
"Mark Williams" <MarkWilliams@.discussions.microsoft.com> wrote in message
news:BD7B78CE-DB95-4E1D-89FC-41F689E94725@.microsoft.com...
> You could use a combination of SQL statements and Scheduled Tasks:
> CREATE PROCEDURE nightlybackup
> AS
> BACKUP DATABASE [yourdb]
> TO DISK = 'c:\backups\dbbackup.dat'
> BACKUP LOG [yourdb]
> TO DISK = 'c:\backups\dblogbackup.dat'
> Now create a cmd script; run the below at a command prompt (all on one
line,
> of course):
> echo osql -d [yourdb] -E -Q "EXEC
> dbo.nightlybackup">>c:\backups\nightlybackup.cmd
> Now add it as a scheduled task (all on one line again):
> schtasks /create /tn nightlybackup /tr c:\backups\nightlybackup.cmd /sc
> daily /st 00:05:00
> This will do a daily backup at 5 minutes after midnight. Do all of this
> logged on as a local administrator.
> --
> "BCS" wrote:
>
error.
retail
Express.
to

Schedule your own reports

Can i in reporting services 200 create some application that loops through and generates the reporting services report and email to the recepiant I specify in the mini application. I do not want to schedule the job in reporting services as the person receiving the email will be different each time based on criteria. If anyone knows the syntax to generate a report and pass the parameters, email and format it would be much appreciated

Lee,

You can using the Reporting Service Web API or you can write .NET code to generate our report, connect with System.web.mail. to email it, and you can use the render of the response to give for different type whether it's HTML, EXCEL and etc...

Here's a URL to get you going:

http://www.codeproject.com/sqlrs/SQLRSViewer.asp

Schedule Trucate and Shrink

Hello all,
I am very new to sql server as we have just replaced our enterprise
application (was access) Our Datafile is around 3GB and the log grows 3GB in
a day. I have auto job routines scheduled in EM and happening every night
for backups etc and they are then auto (scheduled) backed up to tape. The
log file is still 2.5GB in the am after the all the jobs run so I am
shrinking the DB every few days and the log drops to 768KB.
My question is I see all the DBCC shrinfile commands Truncate etc... my
question is (pardon my ignorance) where the heck to I put these, how do they
run and how can i schedule them?
Please be gentle with you reply.
MIf your log naturally grows 3gb a day you should (1) not shrink it and (2)
possibly schedule more frequent log backups. If you require point in time
recovery you should use the truncate log command, if you do not require
point in time recovery, life is easy, set the db to simple recovery mode and
you won't have to worry about the tran logs.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Maureen" <nosend2me@.hotmail.com> wrote in message
news:u9GckFtuDHA.3140@.TK2MSFTNGP11.phx.gbl...
> Hello all,
> I am very new to sql server as we have just replaced our enterprise
> application (was access) Our Datafile is around 3GB and the log grows 3GB
in
> a day. I have auto job routines scheduled in EM and happening every night
> for backups etc and they are then auto (scheduled) backed up to tape. The
> log file is still 2.5GB in the am after the all the jobs run so I am
> shrinking the DB every few days and the log drops to 768KB.
> My question is I see all the DBCC shrinfile commands Truncate etc... my
> question is (pardon my ignorance) where the heck to I put these, how do
they
> run and how can i schedule them?
> Please be gentle with you reply.
> M
>|||Ray,
Thanks for the note.
I need to keep to possible "point in time" recovery. here is a normal day.
12.01 AM E.M.-Sql-Maintenence Plan begins and optimizes/backup data/backup
log report Scheduled daily
5:00 AM Complete Server Backup to Tape NTBACKUP Scheduled including backup
to tape of SqlBackup
8:00 AM Workday begins (Tape changed from [Day1,2,3,4,5 etc]-Nightly to
[Day1,2,3,4,5]-Daily
Regular Work Day....
5:00 PM SqlBackup to tape Complete
5:30 PM Workday end (Tape changed from [Day1,2,3,4,5 etc]-Daily to
[Day1,2,3,4,5]-Nightly
I can easily add a couple more backups to tape or disk during the day. The
server has hardware raid with 5 drives in a raid 5 (data is on these
spmdles) PLUS 2 drives raid 10 for the logs. I am well covered for potential
failure. What I would like to know is where do I issue the Truncate Log
Command AND how do I schedule it to run at 7:30AM every day?
M
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:e9wR7etuDHA.540@.tk2msftngp13.phx.gbl...
> If your log naturally grows 3gb a day you should (1) not shrink it and (2)
> possibly schedule more frequent log backups. If you require point in time
> recovery you should use the truncate log command, if you do not require
> point in time recovery, life is easy, set the db to simple recovery mode
and
> you won't have to worry about the tran logs.
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Maureen" <nosend2me@.hotmail.com> wrote in message
> news:u9GckFtuDHA.3140@.TK2MSFTNGP11.phx.gbl...
> > Hello all,
> >
> > I am very new to sql server as we have just replaced our enterprise
> > application (was access) Our Datafile is around 3GB and the log grows
3GB
> in
> > a day. I have auto job routines scheduled in EM and happening every
night
> > for backups etc and they are then auto (scheduled) backed up to tape.
The
> > log file is still 2.5GB in the am after the all the jobs run so I am
> > shrinking the DB every few days and the log drops to 768KB.
> >
> > My question is I see all the DBCC shrinfile commands Truncate etc... my
> > question is (pardon my ignorance) where the heck to I put these, how do
> they
> > run and how can i schedule them?
> >
> > Please be gentle with you reply.
> > M
> >
> >
>|||Ray,
I have read a little further and think I may have found the answer. Are
these commands issues as part of a SQL job? I have not even looked at this
section of EM as all I have in place currently is done as a maintenance
plan. If this is the case I'll have a look at this Friday as I do not have
access to the server from here.
M
"Maureen" <nosend2me@.hotmail.com> wrote in message
news:Obo8ODuuDHA.1196@.TK2MSFTNGP12.phx.gbl...
> Ray,
> Thanks for the note.
> I need to keep to possible "point in time" recovery. here is a normal
day.
> 12.01 AM E.M.-Sql-Maintenence Plan begins and optimizes/backup data/backup
> log report Scheduled daily
> 5:00 AM Complete Server Backup to Tape NTBACKUP Scheduled including backup
> to tape of SqlBackup
> 8:00 AM Workday begins (Tape changed from [Day1,2,3,4,5 etc]-Nightly to
> [Day1,2,3,4,5]-Daily
> Regular Work Day....
> 5:00 PM SqlBackup to tape Complete
> 5:30 PM Workday end (Tape changed from [Day1,2,3,4,5 etc]-Daily to
> [Day1,2,3,4,5]-Nightly
> I can easily add a couple more backups to tape or disk during the day. The
> server has hardware raid with 5 drives in a raid 5 (data is on these
> spmdles) PLUS 2 drives raid 10 for the logs. I am well covered for
potential
> failure. What I would like to know is where do I issue the Truncate Log
> Command AND how do I schedule it to run at 7:30AM every day?
> M
>
> "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> news:e9wR7etuDHA.540@.tk2msftngp13.phx.gbl...
> > If your log naturally grows 3gb a day you should (1) not shrink it and
(2)
> > possibly schedule more frequent log backups. If you require point in
time
> > recovery you should use the truncate log command, if you do not require
> > point in time recovery, life is easy, set the db to simple recovery mode
> and
> > you won't have to worry about the tran logs.
> >
> > HTH
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Maureen" <nosend2me@.hotmail.com> wrote in message
> > news:u9GckFtuDHA.3140@.TK2MSFTNGP11.phx.gbl...
> > > Hello all,
> > >
> > > I am very new to sql server as we have just replaced our enterprise
> > > application (was access) Our Datafile is around 3GB and the log grows
> 3GB
> > in
> > > a day. I have auto job routines scheduled in EM and happening every
> night
> > > for backups etc and they are then auto (scheduled) backed up to tape.
> The
> > > log file is still 2.5GB in the am after the all the jobs run so I am
> > > shrinking the DB every few days and the log drops to 768KB.
> > >
> > > My question is I see all the DBCC shrinfile commands Truncate etc...
my
> > > question is (pardon my ignorance) where the heck to I put these, how
do
> > they
> > > run and how can i schedule them?
> > >
> > > Please be gentle with you reply.
> > > M
> > >
> > >
> >
> >
>|||If you need point in time recovery, you need to write "backup log"
statements, not truncate log. See BOL for details
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Maureen" <nosend2me@.hotmail.com> wrote in message
news:e8$qHKuuDHA.640@.tk2msftngp13.phx.gbl...
> Ray,
> I have read a little further and think I may have found the answer. Are
> these commands issues as part of a SQL job? I have not even looked at this
> section of EM as all I have in place currently is done as a maintenance
> plan. If this is the case I'll have a look at this Friday as I do not have
> access to the server from here.
> M
>
> "Maureen" <nosend2me@.hotmail.com> wrote in message
> news:Obo8ODuuDHA.1196@.TK2MSFTNGP12.phx.gbl...
> > Ray,
> >
> > Thanks for the note.
> >
> > I need to keep to possible "point in time" recovery. here is a normal
> day.
> >
> > 12.01 AM E.M.-Sql-Maintenence Plan begins and optimizes/backup
data/backup
> > log report Scheduled daily
> > 5:00 AM Complete Server Backup to Tape NTBACKUP Scheduled including
backup
> > to tape of SqlBackup
> > 8:00 AM Workday begins (Tape changed from [Day1,2,3,4,5 etc]-Nightly to
> > [Day1,2,3,4,5]-Daily
> > Regular Work Day....
> > 5:00 PM SqlBackup to tape Complete
> > 5:30 PM Workday end (Tape changed from [Day1,2,3,4,5 etc]-Daily to
> > [Day1,2,3,4,5]-Nightly
> >
> > I can easily add a couple more backups to tape or disk during the day.
The
> > server has hardware raid with 5 drives in a raid 5 (data is on these
> > spmdles) PLUS 2 drives raid 10 for the logs. I am well covered for
> potential
> > failure. What I would like to know is where do I issue the Truncate Log
> > Command AND how do I schedule it to run at 7:30AM every day?
> >
> > M
> >
> >
> >
> > "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> > news:e9wR7etuDHA.540@.tk2msftngp13.phx.gbl...
> > > If your log naturally grows 3gb a day you should (1) not shrink it and
> (2)
> > > possibly schedule more frequent log backups. If you require point in
> time
> > > recovery you should use the truncate log command, if you do not
require
> > > point in time recovery, life is easy, set the db to simple recovery
mode
> > and
> > > you won't have to worry about the tran logs.
> > >
> > > HTH
> > >
> > > --
> > > Ray Higdon MCSE, MCDBA, CCNA
> > > --
> > > "Maureen" <nosend2me@.hotmail.com> wrote in message
> > > news:u9GckFtuDHA.3140@.TK2MSFTNGP11.phx.gbl...
> > > > Hello all,
> > > >
> > > > I am very new to sql server as we have just replaced our enterprise
> > > > application (was access) Our Datafile is around 3GB and the log
grows
> > 3GB
> > > in
> > > > a day. I have auto job routines scheduled in EM and happening every
> > night
> > > > for backups etc and they are then auto (scheduled) backed up to
tape.
> > The
> > > > log file is still 2.5GB in the am after the all the jobs run so I am
> > > > shrinking the DB every few days and the log drops to 768KB.
> > > >
> > > > My question is I see all the DBCC shrinfile commands Truncate etc...
> my
> > > > question is (pardon my ignorance) where the heck to I put these, how
> do
> > > they
> > > > run and how can i schedule them?
> > > >
> > > > Please be gentle with you reply.
> > > > M
> > > >
> > > >
> > >
> > >
> >
> >
>

Schedule the integration packages from the web application

Hi all,

I have developed some SSIS packages and scheduling them by using the SQL Server Agent.

But now I want to change all the scheduling from my web application.

is there anyone could help me this?

Do you mean that you want to alter the schedule? If so, this is not an appropriate question for the SSIS forum. The schedule is defined in SQL Server Agent, NOT SSIS.

I do not know if there is an API available for Agent. Try the SMO forum: https://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=88&SiteID=1

-Jamie

Schedule and Delivery Processor errors

Hi all,

We're running into some random errors on our reporting server (Windows Server 2003, SQL Server 2000 Enterprise). In the application logs, we're seeing several Schedule and Delivery Processor errors (ID 108)...one for each processing extension (FileShare, Excel, HTML, etc.). In the security logs, at the same time of day, are several failure audits with the following info:

EventID: 680
User: NT AUTHORITY\SYSTEM
Description: Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0. Logon account: sqluser.

The odd thing is that the schedules that are failing run perfectly about 98% of the time. Once every few weeks we have a situation like this and all of our reports (approximately 200 of them...mostly Excel, all of them sent via E-Mail) fail.

Any ideas as to what might be causing this, and why it would only happen occasionally? Any help would be appreciated! Thanks!

-Brian
http://searchwindowssecurity.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid45_gci1007131_tax299886,00.html?bucket=ETA&topic=299886|||Thanks Greg, however this link seems to relate to making sure the ASP.NET account has the appropriate permissions on both the web server and the database. In my situation, the account (sqluser) has the correct permissions for the database. The database and report server/IIS are both on the same box if that matters.

In fact, and this is what is really confusing me, everything works just fine for weeks on end...then without warning I start getting these errors and the jobs fail. Same account, same reports, same schedules, same recipients...nothing has changed, yet something has caused these errors. Any other thoughts?
|||

Do you think it could be a DOS attack?

Is it happening the same day of the week? Same time of day?

How many "accounts" are accessing the server? Some versions of SQL have a max amount of connections before it denies access.

Schedule and Delivery processor cannot connect

Hello,
I'm getting the following error on the application log of the event viewer:
Schedule and Delivery processor cannot connect to the report server database.
However I have no trouble to test some reports (e.g. the sample reports provided with reporting services).
What could be wrong with my configuration?
Thanks
CesarCan you look in the reportserverservice<date>.log files for more
information.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cesar" <Cesar@.discussions.microsoft.com> wrote in message
news:BAF05421-386E-4712-8503-A304A1626C24@.microsoft.com...
> Hello,
> I'm getting the following error on the application log of the event
viewer:
> Schedule and Delivery processor cannot connect to the report server
database.
> However I have no trouble to test some reports (e.g. the sample reports
provided with reporting services).
> What could be wrong with my configuration?
> Thanks
> Cesar|||Hello daniel,
On one line of the log says:
"Cannot open database requested in login 'Report Server'. Login fails"
How can I fix that ?
But I had no errors during set up when I configured the account with which reporting services would use to connect to the database.
"Daniel Reib [MSFT]" wrote:
> Can you look in the reportserverservice<date>.log files for more
> information.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Cesar" <Cesar@.discussions.microsoft.com> wrote in message
> news:BAF05421-386E-4712-8503-A304A1626C24@.microsoft.com...
> > Hello,
> >
> > I'm getting the following error on the application log of the event
> viewer:
> >
> > Schedule and Delivery processor cannot connect to the report server
> database.
> >
> > However I have no trouble to test some reports (e.g. the sample reports
> provided with reporting services).
> >
> > What could be wrong with my configuration?
> > Thanks
> > Cesar
>
>