Full text indexing scheduler SQL

Hi all,
I'm hosting a site on DiscountASP and since I have full text enabled
I
need to schedule the population. However, they don't allow using SQL
Enterprise Manager and said I have to use SQL to do it. I'm really
having a hard time finding a sample code. Can someone please show me
an example of doing this? Let's say my database is called
'DatabaseA',
my table is call 'TableA' and I have full text enabled on two columns
'ColA' and 'ColB'.
Thank you
Maz"maflatoun@.gmail.com" wrote:
> Hi all,
> I'm hosting a site on DiscountASP and since I have full text enabled
> I
> need to schedule the population. However, they don't allow using SQL
> Enterprise Manager and said I have to use SQL to do it. I'm really
> having a hard time finding a sample code. Can someone please show me
> an example of doing this? Let's say my database is called
> 'DatabaseA',
> my table is call 'TableA' and I have full text enabled on two columns
> 'ColA' and 'ColB'.
>
> Thank you
> Maz
>
Hi
Look at the topic "Administering Full-Text Features Using SQL Enterprise
Manager" which also has all the Transact-SQL examples for the stored
procedures used to administer FTS.
John

Full Backup and Log backup timing

Hi
When I set up a schedule to backup my database and Tlogs, will I then have
to ensure that the database backup has finished before my Tlog backup job
starts? Will it create any problems if the database backup job is still
running when the Tlog backup job kicks in. Is it somethnig I should avoid
happening if possible?
Regards
SteenSteen
In my copmpany we do every night a complete backup of the database (let me
say at 01 am) and log backup we begin at 8 am in the morning. First thing i
get an email or even sms whether or not the full backup was complete
successful.
You will have to make sure that your full database was successful before the
log backup will start.
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>|||I believe that one of the enhancements in SQL2K is that you can do a log bac
kup while the db backup is
running, something you couldn't do in prior releases.
A quick test seem to confirm that, but of course a quick test in this case i
s not conclusive...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message news:%239tFPa5UEHA.3988@.tk2msftngp13.p
hx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>|||Unfortunately 2000 does not allow this yet either. You can start a Tlog
backup while a Full backup is in progress but it can not finish until the
Full is done. There is no problem doing this as far as errors and such.
Andrew J. Kelly SQL MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> I believe that one of the enhancements in SQL2K is that you can do a log
backup while the db backup is
> running, something you couldn't do in prior releases.
> A quick test seem to confirm that, but of course a quick test in this case
is not conclusive...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
have[vbcol=seagreen]
job[vbcol=seagreen]
avoid[vbcol=seagreen]
>|||Ahh, thanks Andrew!
The database I tested on is only 50 MB in size, I didn't see that wait in th
ere...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message news:uxyW$$5UEHA.644@.tk2msf
tngp13.phx.gbl...
> Unfortunately 2000 does not allow this yet either. You can start a Tlog
> backup while a Full backup is in progress but it can not finish until the
> Full is done. There is no problem doing this as far as errors and such.
> --
> Andrew J. Kelly SQL MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> backup while the db backup is
> is not conclusive...
> news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> have
> job
> avoid
>|||Thanks for your input.
Regards
Steen
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> skrev i
en meddelelse news:%23D%23S2D6UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> Ahh, thanks Andrew!
> The database I tested on is only 50 MB in size, I didn't see that wait in
there...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uxyW$$5UEHA.644@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
in[vbcol=seagreen]
log[vbcol=seagreen]
case[vbcol=seagreen]
then[vbcol=seagreen]
backup[vbcol=seagreen]
still[vbcol=seagreen]
>

Full Backup and Log backup timing

Hi
When I set up a schedule to backup my database and Tlogs, will I then have
to ensure that the database backup has finished before my Tlog backup job
starts? Will it create any problems if the database backup job is still
running when the Tlog backup job kicks in. Is it somethnig I should avoid
happening if possible?
Regards
SteenSteen
In my copmpany we do every night a complete backup of the database (let me
say at 01 am) and log backup we begin at 8 am in the morning. First thing i
get an email or even sms whether or not the full backup was complete
successful.
You will have to make sure that your full database was successful before the
log backup will start.
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>|||I believe that one of the enhancements in SQL2K is that you can do a log backup while the db backup is
running, something you couldn't do in prior releases.
A quick test seem to confirm that, but of course a quick test in this case is not conclusive...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>|||Unfortunately 2000 does not allow this yet either. You can start a Tlog
backup while a Full backup is in progress but it can not finish until the
Full is done. There is no problem doing this as far as errors and such.
--
Andrew J. Kelly SQL MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> I believe that one of the enhancements in SQL2K is that you can do a log
backup while the db backup is
> running, something you couldn't do in prior releases.
> A quick test seem to confirm that, but of course a quick test in this case
is not conclusive...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > When I set up a schedule to backup my database and Tlogs, will I then
have
> > to ensure that the database backup has finished before my Tlog backup
job
> > starts? Will it create any problems if the database backup job is still
> > running when the Tlog backup job kicks in. Is it somethnig I should
avoid
> > happening if possible?
> >
> > Regards
> > Steen
> >
> >
>|||Ahh, thanks Andrew!
The database I tested on is only 50 MB in size, I didn't see that wait in there...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message news:uxyW$$5UEHA.644@.tk2msftngp13.phx.gbl...
> Unfortunately 2000 does not allow this yet either. You can start a Tlog
> backup while a Full backup is in progress but it can not finish until the
> Full is done. There is no problem doing this as far as errors and such.
> --
> Andrew J. Kelly SQL MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> > I believe that one of the enhancements in SQL2K is that you can do a log
> backup while the db backup is
> > running, something you couldn't do in prior releases.
> > A quick test seem to confirm that, but of course a quick test in this case
> is not conclusive...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> > > Hi
> > >
> > > When I set up a schedule to backup my database and Tlogs, will I then
> have
> > > to ensure that the database backup has finished before my Tlog backup
> job
> > > starts? Will it create any problems if the database backup job is still
> > > running when the Tlog backup job kicks in. Is it somethnig I should
> avoid
> > > happening if possible?
> > >
> > > Regards
> > > Steen
> > >
> > >
> >
> >
>|||Thanks for your input.
Regards
Steen
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> skrev i
en meddelelse news:%23D%23S2D6UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> Ahh, thanks Andrew!
> The database I tested on is only 50 MB in size, I didn't see that wait in
there...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uxyW$$5UEHA.644@.tk2msftngp13.phx.gbl...
> > Unfortunately 2000 does not allow this yet either. You can start a Tlog
> > backup while a Full backup is in progress but it can not finish until
the
> > Full is done. There is no problem doing this as far as errors and such.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> > > I believe that one of the enhancements in SQL2K is that you can do a
log
> > backup while the db backup is
> > > running, something you couldn't do in prior releases.
> > > A quick test seem to confirm that, but of course a quick test in this
case
> > is not conclusive...
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> > news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> > > > Hi
> > > >
> > > > When I set up a schedule to backup my database and Tlogs, will I
then
> > have
> > > > to ensure that the database backup has finished before my Tlog
backup
> > job
> > > > starts? Will it create any problems if the database backup job is
still
> > > > running when the Tlog backup job kicks in. Is it somethnig I should
> > avoid
> > > > happening if possible?
> > > >
> > > > Regards
> > > > Steen
> > > >
> > > >
> > >
> > >
> >
> >
>

Full Backup and Log backup timing

Hi
When I set up a schedule to backup my database and Tlogs, will I then have
to ensure that the database backup has finished before my Tlog backup job
starts? Will it create any problems if the database backup job is still
running when the Tlog backup job kicks in. Is it somethnig I should avoid
happening if possible?
Regards
Steen
Steen
In my copmpany we do every night a complete backup of the database (let me
say at 01 am) and log backup we begin at 8 am in the morning. First thing i
get an email or even sms whether or not the full backup was complete
successful.
You will have to make sure that your full database was successful before the
log backup will start.
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>
|||I believe that one of the enhancements in SQL2K is that you can do a log backup while the db backup is
running, something you couldn't do in prior releases.
A quick test seem to confirm that, but of course a quick test in this case is not conclusive...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>
|||Unfortunately 2000 does not allow this yet either. You can start a Tlog
backup while a Full backup is in progress but it can not finish until the
Full is done. There is no problem doing this as far as errors and such.
Andrew J. Kelly SQL MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> I believe that one of the enhancements in SQL2K is that you can do a log
backup while the db backup is
> running, something you couldn't do in prior releases.
> A quick test seem to confirm that, but of course a quick test in this case
is not conclusive...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
have[vbcol=seagreen]
job[vbcol=seagreen]
avoid
>
|||Ahh, thanks Andrew!
The database I tested on is only 50 MB in size, I didn't see that wait in there...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message news:uxyW$$5UEHA.644@.tk2msftngp13.phx.gbl...
> Unfortunately 2000 does not allow this yet either. You can start a Tlog
> backup while a Full backup is in progress but it can not finish until the
> Full is done. There is no problem doing this as far as errors and such.
> --
> Andrew J. Kelly SQL MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> backup while the db backup is
> is not conclusive...
> news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> have
> job
> avoid
>
|||Thanks for your input.
Regards
Steen
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> skrev i
en meddelelse news:%23D%23S2D6UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> Ahh, thanks Andrew!
> The database I tested on is only 50 MB in size, I didn't see that wait in
there...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uxyW$$5UEHA.644@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
the[vbcol=seagreen]
in[vbcol=seagreen]
log[vbcol=seagreen]
case[vbcol=seagreen]
then[vbcol=seagreen]
backup[vbcol=seagreen]
still
>