Database corrupted: schedule

Showing posts with label schedule. Show all posts

Thursday, March 22, 2012

database backup schedule not working

I'm running SQL server 2000 on a Windows Server 2003. I'm trying to schedule
a backup for my databases but it's not sticking. I went under Backup
Database, selected the local disk as a backup destination, clicked on
Schedule and setup my schedule.
Everything looks fine until I say OK and then if I go back to Backup
Database, the schedule is gone.
Expand the Management folder within Enterprise Manager
Open up the SQL Server Agent node
Navigate to the Jobs node
Right-click and choose "New Job"
give the job a name
on the steps tab give the job one (Transact-SQL) step as follows
BACKUP DATABASE master TO DISK = 'c:\master.bak' WITH INIT
hit ok
On the schedules tab hit "New Schedule"
specify the schedule to run.
You can wait for the job to run according to the schedule or you can
right-click on the job and choose "Start Job"
You will want to backup your user databases, master, and model. You will
probably want to choose a backup location other than C. Also, make sure
that you move the files to tape or to another server for safe keeping.
Keith
"Gilbert" <Gilbert@.discussions.microsoft.com> wrote in message
news:AB1E8EBA-62D0-4877-A974-1D5704379665@.microsoft.com...
> I'm running SQL server 2000 on a Windows Server 2003. I'm trying to
schedule
> a backup for my databases but it's not sticking. I went under Backup
> Database, selected the local disk as a backup destination, clicked on
> Schedule and setup my schedule.
> Everything looks fine until I say OK and then if I go back to Backup
> Database, the schedule is gone.
sql

Wednesday, March 21, 2012

Database backup and maintenance plan

In EM, what are the diffeneces between these two under the Management folder
?
I can schedule the database backup in Backup and also can schedule the
database schedule in Database Maintenance Plans ?
I set up the full backup and schedule in 'BackUp', it can create the full
backup file in the directory but cannot view contents by right click the
item on the right pane of 'Backup' folder.Different way of scheduling, quite simply. To understand why you cannot see backups created by maint
plan, read about sp_addumpdevice. Main plan doesn't create backup devices, it addresses files
directly (see the BACKUP command and DISK = 'filename' option.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> In EM, what are the diffeneces between these two under the Management folder
> ?
> I can schedule the database backup in Backup and also can schedule the
> database schedule in Database Maintenance Plans ?
> I set up the full backup and schedule in 'BackUp', it can create the full
> backup file in the directory but cannot view contents by right click the
> item on the right pane of 'Backup' folder.
>|||Another difference between the two is that the backup dialog box simply
allows you do create/schedule a backup..
The database maintenance plan wizard is intended to allow you to set up
several jobs which should cover most of your maintenance needs... not only
backups, but index maintenance, and dbcc checkdb...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> In EM, what are the diffeneces between these two under the Management
folder
> ?
> I can schedule the database backup in Backup and also can schedule the
> database schedule in Database Maintenance Plans ?
> I set up the full backup and schedule in 'BackUp', it can create the full
> backup file in the directory but cannot view contents by right click the
> item on the right pane of 'Backup' folder.
>|||Thanks.
However, I have setup the backup device for the Northwind database for
example in the Management|Backup subfolder, and schedule the full and
differential backup for that, it can backup according to the schedule,
that's fine, BUT I cannot review the schedule of the backup that I created.
I had schedule the full backup at every Sunday and differential backup every
weekday at 5 pm, how do I review the schedule of these backup ?
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uXawQ%23EWEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Another difference between the two is that the backup dialog box simply
> allows you do create/schedule a backup..
> The database maintenance plan wizard is intended to allow you to set up
> several jobs which should cover most of your maintenance needs... not only
> backups, but index maintenance, and dbcc checkdb...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> > In EM, what are the diffeneces between these two under the Management
> folder
> > ?
> >
> > I can schedule the database backup in Backup and also can schedule the
> > database schedule in Database Maintenance Plans ?
> >
> > I set up the full backup and schedule in 'BackUp', it can create the
full
> > backup file in the directory but cannot view contents by right click the
> > item on the right pane of 'Backup' folder.
> >
> >
>|||Look in the SQL Server agent folder. Each time you press "Schedule" in the backup dialog, a SQL
Server Agent job is created.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eaL4RSLWEHA.2928@.tk2msftngp13.phx.gbl...
> Thanks.
> However, I have setup the backup device for the Northwind database for
> example in the Management|Backup subfolder, and schedule the full and
> differential backup for that, it can backup according to the schedule,
> that's fine, BUT I cannot review the schedule of the backup that I created.
> I had schedule the full backup at every Sunday and differential backup every
> weekday at 5 pm, how do I review the schedule of these backup ?
>
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uXawQ%23EWEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > Another difference between the two is that the backup dialog box simply
> > allows you do create/schedule a backup..
> >
> > The database maintenance plan wizard is intended to allow you to set up
> > several jobs which should cover most of your maintenance needs... not only
> > backups, but index maintenance, and dbcc checkdb...
> >
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> > news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> > > In EM, what are the diffeneces between these two under the Management
> > folder
> > > ?
> > >
> > > I can schedule the database backup in Backup and also can schedule the
> > > database schedule in Database Maintenance Plans ?
> > >
> > > I set up the full backup and schedule in 'BackUp', it can create the
> full
> > > backup file in the directory but cannot view contents by right click the
> > > item on the right pane of 'Backup' folder.
> > >
> > >
> >
> >
>|||Yes, I got it, thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ueqsT1OWEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Look in the SQL Server agent folder. Each time you press "Schedule" in the
backup dialog, a SQL
> Server Agent job is created.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:eaL4RSLWEHA.2928@.tk2msftngp13.phx.gbl...
> > Thanks.
> > However, I have setup the backup device for the Northwind database for
> > example in the Management|Backup subfolder, and schedule the full and
> > differential backup for that, it can backup according to the schedule,
> > that's fine, BUT I cannot review the schedule of the backup that I
created.
> >
> > I had schedule the full backup at every Sunday and differential backup
every
> > weekday at 5 pm, how do I review the schedule of these backup ?
> >
> >
> >
> > "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> > news:uXawQ%23EWEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > > Another difference between the two is that the backup dialog box
simply
> > > allows you do create/schedule a backup..
> > >
> > > The database maintenance plan wizard is intended to allow you to set
up
> > > several jobs which should cover most of your maintenance needs... not
only
> > > backups, but index maintenance, and dbcc checkdb...
> > >
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > > www.mariner-usa.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > > "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> > > news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> > > > In EM, what are the diffeneces between these two under the
Management
> > > folder
> > > > ?
> > > >
> > > > I can schedule the database backup in Backup and also can schedule
the
> > > > database schedule in Database Maintenance Plans ?
> > > >
> > > > I set up the full backup and schedule in 'BackUp', it can create the
> > full
> > > > backup file in the directory but cannot view contents by right click
the
> > > > item on the right pane of 'Backup' folder.
> > > >
> > > >
> > >
> > >
> >
> >
>

Database backup ? using Enterprise Manager

Hi I am using enterprise manager (SQL2000 server) and want to set up a
database backup schedule to occure daily at 11pm. Anyhow heard that you can
do this with Enterprise manager and also heard that you must activate the
server agent. Any information is appreciated. Thanks.
Paul G
Software engineer.
Did a quick search and seems to be plenty of information on the subject.
Paul G
Software engineer.
"Paul" wrote:

> Hi I am using enterprise manager (SQL2000 server) and want to set up a
> database backup schedule to occure daily at 11pm. Anyhow heard that you can
> do this with Enterprise manager and also heard that you must activate the
> server agent. Any information is appreciated. Thanks.
> --
> Paul G
> Software engineer.

Database backup ? using Enterprise Manager

Hi I am using enterprise manager (SQL2000 server) and want to set up a
database backup schedule to occure daily at 11pm. Anyhow heard that you can
do this with Enterprise manager and also heard that you must activate the
server agent. Any information is appreciated. Thanks.
--
Paul G
Software engineer.Did a quick search and seems to be plenty of information on the subject.
--
Paul G
Software engineer.
"Paul" wrote:

> Hi I am using enterprise manager (SQL2000 server) and want to set up a
> database backup schedule to occure daily at 11pm. Anyhow heard that you c
an
> do this with Enterprise manager and also heard that you must activate the
> server agent. Any information is appreciated. Thanks.
> --
> Paul G
> Software engineer.

Database backup ? using Enterprise Manager

Hi I am using enterprise manager (SQL2000 server) and want to set up a
database backup schedule to occure daily at 11pm. Anyhow heard that you can
do this with Enterprise manager and also heard that you must activate the
server agent. Any information is appreciated. Thanks.
--
Paul G
Software engineer.Did a quick search and seems to be plenty of information on the subject.
--
Paul G
Software engineer.
"Paul" wrote:
> Hi I am using enterprise manager (SQL2000 server) and want to set up a
> database backup schedule to occure daily at 11pm. Anyhow heard that you can
> do this with Enterprise manager and also heard that you must activate the
> server agent. Any information is appreciated. Thanks.
> --
> Paul G
> Software engineer.

Database Backup

Hi,

Currently i schedule my SQL sever agent to do database backup once in a few days with the default backup file name to ABC. Hence everytime, it will overwrite the previous file. Is there a way for me to auto append date time at the back of my default file name? Eg will be ABC_DD_MM_YYYY
Thanks!

Regards,
weihann.If you right click your database name, choose all tasks -backup database, you can find what you want.

Tuesday, February 14, 2012

Data Transformation Services Revisited

I am trying to export a table from SQL Server to Oracle8i home edition. I want to schedule the export package to run at a certain time. The package gets created, but when the time is reached for the package to execute, it doesn't execute. There are no errors at all. It just doesn't run. The package is there because I see it in the Data Transformation Services->Local Packages list. Any ideas? Thanks.If you scheduled the package to run you should see it Enterprise Manager under the server in Management/SQL Server Agent/Jobs.
There you will see last run status among other things.

Of course the SQL Server Agent needs to be running.|||Its not in the list of jobs. I got no error that the SQL Server Agent isn't running. How do I check to make sure it is running?
Thanks|||Originally posted by exdter
Its not in the list of jobs. I got no error that the SQL Server Agent isn't running. How do I check to make sure it is running?
Thanks

Do a refresh on the jobs. If it isn't there, then that is your problem. After you right-click the DTS package and do schedule, you should see the job in the "Jobs" panel.|||I don't think you would get an error that it is not running

In Enterprise Manage you see if it is running by the small green "play" icon on it. You can start it from there with right clicking on it.
Or you can start it with Service Manager.

It would probably be a good thing to set it to always start automatically.|||The jobs were there, all with error messages. The Server Agent is running as well.|||Then you know the schedule works at least :-)

Can you run the task manually, and does it work without errors then?

Originally posted by exdter
The jobs were there, all with error messages. The Server Agent is running as well.|||Originally posted by exdter
The jobs were there, all with error messages. The Server Agent is running as well.

OK, that's a different error than what you were seeing before (no jobs).

Try double-clicking the job, click the "steps" tab, select the only step, click edit, cut and paste the command to a command prompt and see what you get.

That will probably fail and give you a more detailed error. Otherwise, you probably have a permissions issue.|||Manually the job works. Thanks for your help.|||When I put the line in a command prompt, everything worked. The table was created in Oracle.|||Originally posted by exdter
When I put the line in a command prompt, everything worked. The table was created in Oracle.

If the job reliably fails when automated and reliably works when executed manually, it is almost definitely a permissions issue. Right-click the job, do "Start Job", wait a few minutes, do a refresh, and check if the job does reliably fail when scheduled.

Check who owns that job. Try changing that to sa or local Admin. You also may want to try deleting and recreating the job (I've seen that help).|||I created the job logged in as administrator. I deleted and recreated the job more than once, and it still doesn't run on a schedule. Thanks for your help.|||The scheduled job will run under the credentials the SQL Server Agent has if using Windows integrated security.
For the connection with Oracle I guess you set that in the Oracle connection in the DTS package. (I don't know much about Oracle security).|||I did set the connection to Oracle also in the DTS. Its strange that the package will run manually and not on the schedule.|||Originally posted by exdter
I did set the connection to Oracle also in the DTS. Its strange that the package will run manually and not on the schedule.

This is an almost sure sign of a permissions issue. Did you look at the Windows Event Log? The error message for scheduled jobs should be in there.|||I couldn't find anything in there about it.|||Just to make sure: Have you installed (Oracle) SQL*Net on the SQL Server? SQL*Net is similar to Client Connectivity in SQL Server. It installs all the underlying DLL's, executables, and such that any application (DTS included) would need to connect to an Oracle Database.

If so, can you do a TNSPing to the SID that you are trying to reach? DTS is horribly client bound, so running the package manually would mean that you are running the package from your lap/desk-top.|||I didn't have the SQL* Net installed. Thanks.

Data transformation services

I was told that using DTS will allow me to schedule stored procedures to keep an sql database up to date. For example if a user registers but does not activate the registration, his details will be removed by a stored procedure which is scheduled to run every 24 hours. I use to use the global.asax file to fire a update by using a file containing a the date of the last update and then by adding 24 hours to it, it would execute a SP to delete unwanted data.

I have tried to install DTS with no success. I am running the following

Visual web studio express

SQL 2005 Express. (From SQLExpr_exe) and I have told it to install all the extra components

Installed SQLEXPR_Toolkit.exe with all its options

Installed SQLServer2005_DTS.MSI

When I go into the sql server using MS SQL Server Management Studio Express. I cannot see the Data transformation services node. I have also just installed server reports which I had no problems installing.

Can somebody please help me.

DTS is a SQL2000 component; SQL2005 hasa totally rewritten equivalent called SSIS. An SSIS (SQL Server Integration Sercvices) job amongst other things will run stored procedures for you. However it is SQL Agent that provides the scheduling capability.

|||

Thanks for the reply. I need to know where to download the ssis installation application. The other thing is my service provider that I use uses SQL2000. Im developing in SQL Express 2005. How will I deploy the scheduled jobs to there server if im using the newer version.

Regards

Thursday, March 22, 2012

database backup schedule not working

Wednesday, March 21, 2012

Database backup and maintenance plan

Database backup and maintenance plan

Database backup and maintenance plan

Database backup ? using Enterprise Manager

Database backup ? using Enterprise Manager

Database backup ? using Enterprise Manager

Database Backup

Tuesday, February 14, 2012

Data Transformation Services Revisited

Data transformation services

Database corrupted

Blog Archive

About Me