How to run backup in EM?

I'm running SQL Server 2000 on Win2k Server. I've right clicked on a
database, selected all task and backup database. How do I run this backup
manually to check it?
Thanks,
BrettBrett,
Did you mean to ask you want to check if the backup file is valid? If so,
try a restore.You can do it via EM (all tasks | restore database) or through
the RESTORE DATABASE command in Query analyzer.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brett" <myaccount@.cygen.com> wrote in message
news:OevbiKBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> I'm running SQL Server 2000 on Win2k Server. I've right clicked on a
> database, selected all task and backup database. How do I run this backup
> manually to check it?
> Thanks,
> Brett
>|||I haven't run the backup yet. There is not file to check.
Thanks,
Brett
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uImszPBaDHA.2336@.TK2MSFTNGP09.phx.gbl...
> Brett,
> Did you mean to ask you want to check if the backup file is valid? If so,
> try a restore.You can do it via EM (all tasks | restore database) or
through
> the RESTORE DATABASE command in Query analyzer.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Brett" <myaccount@.cygen.com> wrote in message
> news:OevbiKBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > I'm running SQL Server 2000 on Win2k Server. I've right clicked on a
> > database, selected all task and backup database. How do I run this
backup
> > manually to check it?
> >
> > Thanks,
> > Brett
> >
> >
>|||Brett,
Ok.So you can backup the database in the way you mentioned in EM.Are you
facing any problems?The equivalent T-SQL command is BACKUP DATABASE.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brett" <myaccount@.cygen.com> wrote in message
news:%23S$LMUBaDHA.1832@.TK2MSFTNGP09.phx.gbl...
> I haven't run the backup yet. There is not file to check.
> Thanks,
> Brett
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:uImszPBaDHA.2336@.TK2MSFTNGP09.phx.gbl...
> > Brett,
> >
> > Did you mean to ask you want to check if the backup file is valid? If
so,
> > try a restore.You can do it via EM (all tasks | restore database) or
> through
> > the RESTORE DATABASE command in Query analyzer.
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Brett" <myaccount@.cygen.com> wrote in message
> > news:OevbiKBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > > I'm running SQL Server 2000 on Win2k Server. I've right clicked on a
> > > database, selected all task and backup database. How do I run this
> backup
> > > manually to check it?
> > >
> > > Thanks,
> > > Brett
> > >
> > >
> >
> >
>|||I'm asking how to backup the database. It is scheduled but I'd like to back
up before the scheduled date.
Brett
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23QkNLWBaDHA.2520@.TK2MSFTNGP09.phx.gbl...
> Brett,
> Ok.So you can backup the database in the way you mentioned in EM.Are you
> facing any problems?The equivalent T-SQL command is BACKUP DATABASE.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Brett" <myaccount@.cygen.com> wrote in message
> news:%23S$LMUBaDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > I haven't run the backup yet. There is not file to check.
> >
> > Thanks,
> > Brett
> >
> > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > news:uImszPBaDHA.2336@.TK2MSFTNGP09.phx.gbl...
> > > Brett,
> > >
> > > Did you mean to ask you want to check if the backup file is valid? If
> so,
> > > try a restore.You can do it via EM (all tasks | restore database) or
> > through
> > > the RESTORE DATABASE command in Query analyzer.
> > >
> > > --
> > > Dinesh.
> > > SQL Server FAQ at
> > > http://www.tkdinesh.com
> > >
> > > "Brett" <myaccount@.cygen.com> wrote in message
> > > news:OevbiKBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > > > I'm running SQL Server 2000 on Win2k Server. I've right clicked on
a
> > > > database, selected all task and backup database. How do I run this
> > backup
> > > > manually to check it?
> > > >
> > > > Thanks,
> > > > Brett
> > > >
> > > >
> > >
> > >
> >
> >
>|||Brett,
Try this syntax in Query analyzer..
BACKUP DATABASE <databasename>
TO DISK='c:\data\database.BAK'
Since you already have the sql job scheduled, just right click and start the
job to run it manually.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brett" <myaccount@.cygen.com> wrote in message
news:u2ms6uBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> I'm asking how to backup the database. It is scheduled but I'd like to
back
> up before the scheduled date.
> Brett
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:%23QkNLWBaDHA.2520@.TK2MSFTNGP09.phx.gbl...
> > Brett,
> >
> > Ok.So you can backup the database in the way you mentioned in EM.Are you
> > facing any problems?The equivalent T-SQL command is BACKUP DATABASE.
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Brett" <myaccount@.cygen.com> wrote in message
> > news:%23S$LMUBaDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > I haven't run the backup yet. There is not file to check.
> > >
> > > Thanks,
> > > Brett
> > >
> > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > news:uImszPBaDHA.2336@.TK2MSFTNGP09.phx.gbl...
> > > > Brett,
> > > >
> > > > Did you mean to ask you want to check if the backup file is valid?
If
> > so,
> > > > try a restore.You can do it via EM (all tasks | restore database) or
> > > through
> > > > the RESTORE DATABASE command in Query analyzer.
> > > >
> > > > --
> > > > Dinesh.
> > > > SQL Server FAQ at
> > > > http://www.tkdinesh.com
> > > >
> > > > "Brett" <myaccount@.cygen.com> wrote in message
> > > > news:OevbiKBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > > > > I'm running SQL Server 2000 on Win2k Server. I've right clicked
on
> a
> > > > > database, selected all task and backup database. How do I run this
> > > backup
> > > > > manually to check it?
> > > > >
> > > > > Thanks,
> > > > > Brett
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I see the job listed. When I right click and start job, nothing happens.
Any suggestions?
Brett
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:u7%23XK1BaDHA.1640@.TK2MSFTNGP10.phx.gbl...
> Brett,
> Try this syntax in Query analyzer..
> BACKUP DATABASE <databasename>
> TO DISK='c:\data\database.BAK'
> Since you already have the sql job scheduled, just right click and start
the
> job to run it manually.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Brett" <myaccount@.cygen.com> wrote in message
> news:u2ms6uBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > I'm asking how to backup the database. It is scheduled but I'd like to
> back
> > up before the scheduled date.
> >
> > Brett
> > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > news:%23QkNLWBaDHA.2520@.TK2MSFTNGP09.phx.gbl...
> > > Brett,
> > >
> > > Ok.So you can backup the database in the way you mentioned in EM.Are
you
> > > facing any problems?The equivalent T-SQL command is BACKUP DATABASE.
> > >
> > > --
> > > Dinesh.
> > > SQL Server FAQ at
> > > http://www.tkdinesh.com
> > >
> > > "Brett" <myaccount@.cygen.com> wrote in message
> > > news:%23S$LMUBaDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > > I haven't run the backup yet. There is not file to check.
> > > >
> > > > Thanks,
> > > > Brett
> > > >
> > > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > > news:uImszPBaDHA.2336@.TK2MSFTNGP09.phx.gbl...
> > > > > Brett,
> > > > >
> > > > > Did you mean to ask you want to check if the backup file is valid?
> If
> > > so,
> > > > > try a restore.You can do it via EM (all tasks | restore database)
or
> > > > through
> > > > > the RESTORE DATABASE command in Query analyzer.
> > > > >
> > > > > --
> > > > > Dinesh.
> > > > > SQL Server FAQ at
> > > > > http://www.tkdinesh.com
> > > > >
> > > > > "Brett" <myaccount@.cygen.com> wrote in message
> > > > > news:OevbiKBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > > > > > I'm running SQL Server 2000 on Win2k Server. I've right clicked
> on
> > a
> > > > > > database, selected all task and backup database. How do I run
this
> > > > backup
> > > > > > manually to check it?
> > > > > >
> > > > > > Thanks,
> > > > > > Brett
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Brett,
Well, "nothing happens", does not mean anything - success or failure.The job
wont give you a dialog box mentioning the status upon completion.You can
look into the code inside the sql job, see where the backup is being made
and check the filesystem whether that file was created.Right click on the
job | refresh and then check the job history whether it ran
successfully.Also, did you try the syntax that I mentioned?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brett" <myaccount@.cygen.com> wrote in message
news:O7RtggCaDHA.656@.tk2msftngp13.phx.gbl...
> I see the job listed. When I right click and start job, nothing happens.
> Any suggestions?
> Brett
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:u7%23XK1BaDHA.1640@.TK2MSFTNGP10.phx.gbl...
> > Brett,
> >
> > Try this syntax in Query analyzer..
> >
> > BACKUP DATABASE <databasename>
> > TO DISK='c:\data\database.BAK'
> >
> > Since you already have the sql job scheduled, just right click and start
> the
> > job to run it manually.
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Brett" <myaccount@.cygen.com> wrote in message
> > news:u2ms6uBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > > I'm asking how to backup the database. It is scheduled but I'd like
to
> > back
> > > up before the scheduled date.
> > >
> > > Brett
> > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > news:%23QkNLWBaDHA.2520@.TK2MSFTNGP09.phx.gbl...
> > > > Brett,
> > > >
> > > > Ok.So you can backup the database in the way you mentioned in EM.Are
> you
> > > > facing any problems?The equivalent T-SQL command is BACKUP DATABASE.
> > > >
> > > > --
> > > > Dinesh.
> > > > SQL Server FAQ at
> > > > http://www.tkdinesh.com
> > > >
> > > > "Brett" <myaccount@.cygen.com> wrote in message
> > > > news:%23S$LMUBaDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > > > I haven't run the backup yet. There is not file to check.
> > > > >
> > > > > Thanks,
> > > > > Brett
> > > > >
> > > > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > > > news:uImszPBaDHA.2336@.TK2MSFTNGP09.phx.gbl...
> > > > > > Brett,
> > > > > >
> > > > > > Did you mean to ask you want to check if the backup file is
valid?
> > If
> > > > so,
> > > > > > try a restore.You can do it via EM (all tasks | restore
database)
> or
> > > > > through
> > > > > > the RESTORE DATABASE command in Query analyzer.
> > > > > >
> > > > > > --
> > > > > > Dinesh.
> > > > > > SQL Server FAQ at
> > > > > > http://www.tkdinesh.com
> > > > > >
> > > > > > "Brett" <myaccount@.cygen.com> wrote in message
> > > > > > news:OevbiKBaDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > > > > > > I'm running SQL Server 2000 on Win2k Server. I've right
clicked
> > on
> > > a
> > > > > > > database, selected all task and backup database. How do I run
> this
> > > > > backup
> > > > > > > manually to check it?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Brett
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>