Full Text Searching

I've assumed responsibilty for a sqlserver 2000 that has many databases and has only 1 database that uses full text searching. That 1 application now wishes for me to update the noise words file to remove the single characters.

As far as I can tell, no other application is using the full text searching since I don't see any catalogs created for any of them.

So, if no other databases and applications in this sqlserver have catalogs created for them, can I safely assume that changing the noise words file will not impact any of them even if the other databases do have text fields in some tables?First, which version of SQL are you using? What edition?

Second, thanks for your question; I went Googling for some answers and found some other links to (unrelated) stuff that I found useful.

Third, I don't have the "textbook" answer (I'm still googling), but I found this link on M$ site: http://support.microsoft.com/kb/905617. I hope it helps.

I'll continue to dig around.

Regards,

hmscott|||thanks for any help!
It's sql server 2000 standard edition - SP4.sql

Full Text Search know which row has error in indexing

Hello everybody,
I have installed SQLServer 2005 for take advantage of full text seach
features.
When I start full population, there are some rows that cause error and not
are indexed.
I see the log in C:\Programmi\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\SQLFT0000700005.LOG. In this file there are seven
rows that have error and for everyone a line that say:
"Error '0x8004fd01: The IFilter::Init() function call failed.' ...
full-text key value 0x495532303045594154504B55. Attempt will be made to
reindex it. The component 'pdffilt.dll' reported error while indexing.
Component path 'C:\Programmi\Foxit Software\Foxit PDF IFilter\pdffilt.dll'."
With different full-text key value for every line.
My question is:
1) Start from a full-text key (ie. 0x495532303045594154504B55), how I arrive
to the record in the source table for understand which is the
problem?Otherwise how can I examine the problem if I don't know the row that
cause the error?
2) What is the error 0x8004fd01?
3) Could be that the PDF filter of Foxit is better than Adobe? With Adobe
filter (version 6) my full pupulation is endless!
Thanks!
OK resolved !!!
1)The hexadecimal value must to be converted to decimal and then to ASCII
(http://www.vortex.prodigynet.co.uk/misc/ascii_conv.html)
2) Probably due to the incorrect format because changing the type column
value from ".pdf" to ".txt" the problem has been resolved!!!
3) Wait your opinions :-)
NicolaZap
"NicolaZap" wrote:

> Hello everybody,
> I have installed SQLServer 2005 for take advantage of full text seach
> features.
> When I start full population, there are some rows that cause error and not
> are indexed.
> I see the log in C:\Programmi\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\SQLFT0000700005.LOG. In this file there are seven
> rows that have error and for everyone a line that say:
> "Error '0x8004fd01: The IFilter::Init() function call failed.' ...
> full-text key value 0x495532303045594154504B55. Attempt will be made to
> reindex it. The component 'pdffilt.dll' reported error while indexing.
> Component path 'C:\Programmi\Foxit Software\Foxit PDF IFilter\pdffilt.dll'."
> With different full-text key value for every line.
>
> My question is:
> 1) Start from a full-text key (ie. 0x495532303045594154504B55), how I arrive
> to the record in the source table for understand which is the
> problem?Otherwise how can I examine the problem if I don't know the row that
> cause the error?
> 2) What is the error 0x8004fd01?
> 3) Could be that the PDF filter of Foxit is better than Adobe? With Adobe
> filter (version 6) my full pupulation is endless!
>
> Thanks!
>
|||Is this the 64 bit version of SQL server? If so you should be using Foxit.
"NicolaZap" <NicolaZap@.discussions.microsoft.com> wrote in message
news:091F34B8-1140-4A74-9D2A-03F02B00DB8A@.microsoft.com...[vbcol=seagreen]
> OK resolved !!!
> 1)The hexadecimal value must to be converted to decimal and then to ASCII
> (http://www.vortex.prodigynet.co.uk/misc/ascii_conv.html)
> 2) Probably due to the incorrect format because changing the type column
> value from ".pdf" to ".txt" the problem has been resolved!!!
> 3) Wait your opinions :-)
>
> NicolaZap
>
> "NicolaZap" wrote:
|||NO, it is the 32 bit versione of SQLServer2005.
"Hilary Cotter" wrote:

> Is this the 64 bit version of SQL server? If so you should be using Foxit.
> "NicolaZap" <NicolaZap@.discussions.microsoft.com> wrote in message
> news:091F34B8-1140-4A74-9D2A-03F02B00DB8A@.microsoft.com...
>
>

Full Text Search know which row has error in indexing

Hello everybody,

I have installed SQLServer 2005 for take advantage of full text seach features.

When I start full population, there are some rows that cause error and not are indexed.

I see the log in C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLFT0000700005.LOG. In this file there are seven rows that have error and for everyone a line that say:

"Error '0x8004fd01: The IFilter::Init() function call failed.' ... full-text key value 0x495532303045594154504B55. Attempt will be made to reindex it. The component 'pdffilt.dll' reported error while indexing. Component path 'C:\Programmi\Foxit Software\Foxit PDF IFilter\pdffilt.dll'."

With different full-text key value for every line.

My question is:

1) Start from a full-text key (ie. 0x495532303045594154504B55), how I arrive to the record in the source table for understand which is the problem?Otherwise how can I examine the problem if I don't know the row that cause the error?

2) What is the error 0x8004fd01?

3) Could be that the PDF filter of Foxit is better than Adobe? With Adobe filter (version 6) my full pupulation is endless!

Thanks!

OK resolved

1)The hexadecimal value must to be converted to decimal and then to ASCII (http://www.vortex.prodigynet.co.uk/misc/ascii_conv.html)

2) Probably due to the incorrect format because changing the type column value from ".pdf" to ".txt" the problem has been resolved!!!

3) Wait your opinions :-)

NicolaZap

Full text search in SQL Server 2000

I have one question about full text search in SQl
Server 2000/2005.
I have one table which has 7 text columns. I want to
retrieve all rows that have the search word in either
of those 7 columns.
I want to know if there is a way to add weight to
those columns so SQL Server can better rank the result
set. For example, column 1 has weight 1 and column 2
has weight 0.1. So records that have search word in
column 1 will rank higher that those having search
word only in column 2.

Thanks a lot,

Baoxin

Unfortunately, There is no standard way to do this.
You can have to play around with regular expressions..

Full Text Search

Hi,

Would below mentioned thing is possible in sqlserver 2005 full text.

User Table - Table

Id Description - Column name

1 'Mission Impossible' - a row

I want to ge this row if the search criteria is 'pos'. it is simillar to ' %pos%' in like search

is it possible to get that row using Contains() or Freetext(). I tried the following, but it doesnt return any rows.

CONTAINS(Description, ' "*pos*" ')

~ Arjun

SQLServer 2005 does not support arbitrary substring or regular expression yet. Right now you can only do prefix using fulltext.

|||

have u enabled the full text search in your server.

if so then you need not give the % symbol in the text which is to be searched. There is another option in the CONTAINS function.checkt it out.

please try this.

Ravi.

Full text Pattern Search

Hi,
Would below mentioned thing is possible in sqlserver 2005 full text.
User Table - Table
Id Description - Column name
1 'Mission Impossible' - a row
I want to ge this row if the search criteria is 'pos'. it is simillar
to ' %pos%' in like search
is it possible to get that row using Contains() or Freetext(). I
tried the following, but it doesnt return any rows.
CONTAINS(Description, ' "*pos*" ')
~ Arjun
No, you can't do this directly. While you can do some suffix (end of word)
based searches, you can't do prefix (beginning of word) based searches.
It may be possible to use the thesaurus expansion feature if you know in
advance what all stem would be.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<priyananth@.gmail.com> wrote in message
news:1160545045.049080.147130@.m73g2000cwd.googlegr oups.com...
> Hi,
> Would below mentioned thing is possible in sqlserver 2005 full text.
> User Table - Table
> Id Description - Column name
> 1 'Mission Impossible' - a row
> I want to ge this row if the search criteria is 'pos'. it is simillar
> to ' %pos%' in like search
> is it possible to get that row using Contains() or Freetext(). I
> tried the following, but it doesnt return any rows.
> CONTAINS(Description, ' "*pos*" ')
> ~ Arjun
>
|||Hi Hilary,
Thank you for u r reply. Would it be possible to modify the indexing
mechanism which does. or could you please explain how to do it in
thesaurus.
Thanks.
~Arjun.
Hilary Cotter wrote:[vbcol=seagreen]
> No, you can't do this directly. While you can do some suffix (end of word)
> based searches, you can't do prefix (beginning of word) based searches.
> It may be possible to use the thesaurus expansion feature if you know in
> advance what all stem would be.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <priyananth@.gmail.com> wrote in message
> news:1160545045.049080.147130@.m73g2000cwd.googlegr oups.com...
|||Hi Hilary,
Thank you for u r reply. Would it be possible to modify the indexing
mechanism which does. or could you please explain how to do it in
thesaurus.
Thanks.
~Arjun.
Hilary Cotter wrote:[vbcol=seagreen]
> No, you can't do this directly. While you can do some suffix (end of word)
> based searches, you can't do prefix (beginning of word) based searches.
> It may be possible to use the thesaurus expansion feature if you know in
> advance what all stem would be.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <priyananth@.gmail.com> wrote in message
> news:1160545045.049080.147130@.m73g2000cwd.googlegr oups.com...
|||You would have to write your own word breaker to do this, and then write a
stemmer to stem for prefixes. I still don't think it can be done.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<priyananth@.gmail.com> wrote in message
news:1161075470.863928.272330@.i3g2000cwc.googlegro ups.com...
> Hi Hilary,
> Thank you for u r reply. Would it be possible to modify the indexing
> mechanism which does. or could you please explain how to do it in
> thesaurus.
> Thanks.
> ~Arjun.
>
> Hilary Cotter wrote:
>
|||I have the same problem.
It seems crippling that full text indexing does not support searching for
terms in the middle of token. Is there really that great of a demand for
searching the beginnings of words? Are there any third party products you
can recommend that will help me provide a search feature that will integrate
with SQL server?
CONTAINS term* works great but doesn't return the results I need and
'%term%' is far too slow to use in a production environment over 169000 rows
and multiple columns.
Your input is greatly appreciated.
"Hilary Cotter" wrote:

> You would have to write your own word breaker to do this, and then write a
> stemmer to stem for prefixes. I still don't think it can be done.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <priyananth@.gmail.com> wrote in message
> news:1161075470.863928.272330@.i3g2000cwc.googlegro ups.com...
>
>
|||You might want to look at Lucene. The story on its performance is complex.
Basically SQL FTS does a really good job and offers better performance than
Lucene on a single server when you get big. When you get big you start
needing many machines to scale using lucene. The other problem with lucence
is that when you want to do property searches you end up storing data in
your full-text index and you search response times decline radically. So you
need to partition which means more machines.
How about you return your results from sql fts and then trim them using the
like? You will need to use the thesaurus option to expand your search
criteria to all possible terms you might be looking for.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Uriah" <Uriah@.discussions.microsoft.com> wrote in message
news:521E3F54-443B-4855-9A80-5DB71C3096F2@.microsoft.com...[vbcol=seagreen]
>I have the same problem.
> It seems crippling that full text indexing does not support searching for
> terms in the middle of token. Is there really that great of a demand for
> searching the beginnings of words? Are there any third party products you
> can recommend that will help me provide a search feature that will
> integrate
> with SQL server?
> CONTAINS term* works great but doesn't return the results I need and
> '%term%' is far too slow to use in a production environment over 169000
> rows
> and multiple columns.
> Your input is greatly appreciated.
> "Hilary Cotter" wrote:
|||My goal is to have a customer searching for parts over several fields and
finding any one of several tokens anywhere within the text (similar to the
LIKE '%term%' functionality). For example, they might want to search for
'56789' and get back the part with part number 'GAR56789'. I don't see how
it is possible to do that with FTS at all. If I knew what the search terms
were going to be I could certainly pre-add them to the thesaurus but the
point of the search is that I can't predict what terms they might enter.
Maybe this is where SQL server functionality breaks down and it's time to
move on to search appliance or software platform. I'll take a look at Lucene.
"Hilary Cotter" wrote:

> You might want to look at Lucene. The story on its performance is complex.
> Basically SQL FTS does a really good job and offers better performance than
> Lucene on a single server when you get big. When you get big you start
> needing many machines to scale using lucene. The other problem with lucence
> is that when you want to do property searches you end up storing data in
> your full-text index and you search response times decline radically. So you
> need to partition which means more machines.
> How about you return your results from sql fts and then trim them using the
> like? You will need to use the thesaurus option to expand your search
> criteria to all possible terms you might be looking for.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Uriah" <Uriah@.discussions.microsoft.com> wrote in message
> news:521E3F54-443B-4855-9A80-5DB71C3096F2@.microsoft.com...
>
>
|||If it is always a prefix you might want to store your content in reverse and
then reverse your query and do a wildcard.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Uriah" <Uriah@.discussions.microsoft.com> wrote in message
news:B695EBD3-11F8-4DEA-A81D-A1828178C577@.microsoft.com...[vbcol=seagreen]
> My goal is to have a customer searching for parts over several fields and
> finding any one of several tokens anywhere within the text (similar to the
> LIKE '%term%' functionality). For example, they might want to search for
> '56789' and get back the part with part number 'GAR56789'. I don't see
> how
> it is possible to do that with FTS at all. If I knew what the search
> terms
> were going to be I could certainly pre-add them to the thesaurus but the
> point of the search is that I can't predict what terms they might enter.
> Maybe this is where SQL server functionality breaks down and it's time to
> move on to search appliance or software platform. I'll take a look at
> Lucene.
> "Hilary Cotter" wrote:

Full Text Catalog not appearing

Hi
I've got SQLServer 2000 (think it's the developer version) installed on my
Win2000 box.
I've just added the full text catalogue component to my SQLServer
However, when I connect to it using Enterprise Manager, under each database
I only see the options:
Diagrams
Tables
Views
Stored Procedures
Users
Roles
Rules
Defaults
User Defined Data Types
User Defined Functions
When I connect to another server, I also see the option
Full-text catalogs
What is it that I need to do to make this option appear?
Thanks
Griff
Okay - found that I require Server (workstation doesn't support this)

Full Text Catalog not appearing

Hi
I've got SQLServer 2000 (think it's the developer version) installed on my
Win2000 box.
I've just added the full text catalogue component to my SQLServer
However, when I connect to it using Enterprise Manager, under each database
I only see the options:
Diagrams
Tables
Views
Stored Procedures
Users
Roles
Rules
Defaults
User Defined Data Types
User Defined Functions
When I connect to another server, I also see the option
Full-text catalogs
What is it that I need to do to make this option appear?
Thanks
GriffOkay - found that I require Server (workstation doesn't support this)

Full Text Catalog not appearing

Hi
I've got SQLServer 2000 (think it's the developer version) installed on my
Win2000 box.
I've just added the full text catalogue component to my SQLServer
However, when I connect to it using Enterprise Manager, under each database
I only see the options:
Diagrams
Tables
Views
Stored Procedures
Users
Roles
Rules
Defaults
User Defined Data Types
User Defined Functions
When I connect to another server, I also see the option
Full-text catalogs
What is it that I need to do to make this option appear?
Thanks
GriffOkay - found that I require Server (workstation doesn't support this)

Full backup without change archive bit

Here's the scenario:
I set a maintenance plan for sqlserver:
monday morning : full backup
in 6 days rest : differential backup
Sometimes I need to make a full backup of some databases and send to client.
I've got a problem, when I have to make a full backup for example in friday
for someone , because all next differential backups from maintenance plan
are wrong.
(include only differences from friday - not from monday)
So I have a question. How to make a full backup without reset an archive
bit?.
Any idea ?
Thanks to all in advance for your worthy assistance,
Radoslaw PutekRadek
Can you perfom full BACKUP DATABASE on friday within another job ,I mean not
by maintenance plan?
"Radek" <SPAM_putti@.poczta.onet.pl> wrote in message
news:bnql59$77a$1@.atlantis.news.tpi.pl...
> Here's the scenario:
> I set a maintenance plan for sqlserver:
> monday morning : full backup
> in 6 days rest : differential backup
> Sometimes I need to make a full backup of some databases and send to
client.
> I've got a problem, when I have to make a full backup for example in
friday
> for someone , because all next differential backups from maintenance plan
> are wrong.
> (include only differences from friday - not from monday)
> So I have a question. How to make a full backup without reset an archive
> bit?.
> Any idea ?
> Thanks to all in advance for your worthy assistance,
> Radoslaw Putek
>|||> > Here's the scenario:
> > I set a maintenance plan for sqlserver:
> > monday morning : full backup
> > in 6 days rest : differential backup
> >
> > Sometimes I need to make a full backup of some databases and send to
> client.
> > I've got a problem, when I have to make a full backup for example in
> friday
> > for someone , because all next differential backups from maintenance
plan
> > are wrong.
> > (include only differences from friday - not from monday)
> >
> > So I have a question. How to make a full backup without reset an archive
> > bit?.
> > Any idea ?
> >
> > Thanks to all in advance for your worthy assistance,
> >
> > Radoslaw Putek
--
> Radek
> Can you perfom full BACKUP DATABASE on friday within another job ,I mean
not
> by maintenance plan?
>
--
I used my own backup procedures in jobs.
I have over 500 databases and these procedures make me :
SQL_20031029_FULL catalog
database1_full.bac
database2_full.bac
...
SQL_20031030_DIFF catalog
database1_diff.bac
database2_diff.bac
...
.....
And when i make a full backup of some databases in friday(for example) my
restore plan doesn't work.
Radoslaw Putek|||Radek
I'd go with writing stored procedure that accep parameter as database id.
If you were asked to backup particular database/or databases you just put
their id as parameter, that's all.
"Radek" <SPAM_putti@.poczta.onet.pl> wrote in message
news:bnqn9o$ht2$1@.atlantis.news.tpi.pl...
> > > Here's the scenario:
> > > I set a maintenance plan for sqlserver:
> > > monday morning : full backup
> > > in 6 days rest : differential backup
> > >
> > > Sometimes I need to make a full backup of some databases and send to
> > client.
> > > I've got a problem, when I have to make a full backup for example in
> > friday
> > > for someone , because all next differential backups from maintenance
> plan
> > > are wrong.
> > > (include only differences from friday - not from monday)
> > >
> > > So I have a question. How to make a full backup without reset an
archive
> > > bit?.
> > > Any idea ?
> > >
> > > Thanks to all in advance for your worthy assistance,
> > >
> > > Radoslaw Putek
> --
> > Radek
> > Can you perfom full BACKUP DATABASE on friday within another job ,I mean
> not
> > by maintenance plan?
> >
> --
> I used my own backup procedures in jobs.
> I have over 500 databases and these procedures make me :
> SQL_20031029_FULL catalog
> database1_full.bac
> database2_full.bac
> ...
> SQL_20031030_DIFF catalog
> database1_diff.bac
> database2_diff.bac
> ...
> .....
> And when i make a full backup of some databases in friday(for example) my
> restore plan doesn't work.
> Radoslaw Putek
>
>|||Radek,
As I understand it, your problem is that your diff backups will be based on that "extra" database
backup, something you don't want them to be. I'm fairly certain that you cannot do that, I'm afraid.
Detaching might be an option (but that is not fully online, of course).
This seems like a valid request for sqlwish@.microsoft.com.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Radek" <SPAM_putti@.poczta.onet.pl> wrote in message news:bnql59$77a$1@.atlantis.news.tpi.pl...
> Here's the scenario:
> I set a maintenance plan for sqlserver:
> monday morning : full backup
> in 6 days rest : differential backup
> Sometimes I need to make a full backup of some databases and send to client.
> I've got a problem, when I have to make a full backup for example in friday
> for someone , because all next differential backups from maintenance plan
> are wrong.
> (include only differences from friday - not from monday)
> So I have a question. How to make a full backup without reset an archive
> bit?.
> Any idea ?
> Thanks to all in advance for your worthy assistance,
> Radoslaw Putek
>|||Ok
Now I see what you mean?
Perhaps detach a database will be an option but I really don't know another
solution
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OdR673snDHA.2272@.tk2msftngp13.phx.gbl...
> Radek
> I'd go with writing stored procedure that accep parameter as database id.
> If you were asked to backup particular database/or databases you just put
> their id as parameter, that's all.
>
> "Radek" <SPAM_putti@.poczta.onet.pl> wrote in message
> news:bnqn9o$ht2$1@.atlantis.news.tpi.pl...
> > > > Here's the scenario:
> > > > I set a maintenance plan for sqlserver:
> > > > monday morning : full backup
> > > > in 6 days rest : differential backup
> > > >
> > > > Sometimes I need to make a full backup of some databases and send to
> > > client.
> > > > I've got a problem, when I have to make a full backup for example in
> > > friday
> > > > for someone , because all next differential backups from
maintenance
> > plan
> > > > are wrong.
> > > > (include only differences from friday - not from monday)
> > > >
> > > > So I have a question. How to make a full backup without reset an
> archive
> > > > bit?.
> > > > Any idea ?
> > > >
> > > > Thanks to all in advance for your worthy assistance,
> > > >
> > > > Radoslaw Putek
> > --
> > > Radek
> > > Can you perfom full BACKUP DATABASE on friday within another job ,I
mean
> > not
> > > by maintenance plan?
> > >
> > --
> > I used my own backup procedures in jobs.
> > I have over 500 databases and these procedures make me :
> > SQL_20031029_FULL catalog
> > database1_full.bac
> > database2_full.bac
> > ...
> > SQL_20031030_DIFF catalog
> > database1_diff.bac
> > database2_diff.bac
> > ...
> > .....
> > And when i make a full backup of some databases in friday(for example)
my
> > restore plan doesn't work.
> >
> > Radoslaw Putek
> >
> >
> >
> >
>

FULL Backup question

Hello everybody,
I am very newbie in sqlserver and I would to ask you a question.
I would like to backup my database through backup wizard and I would
like to automatic it for everyday full backup. What to you think it is
better database maintenance planner or backup wizard.
Could someone help me on that?
inaIf you are only doing a scheduling for a backup, I would use the richer
backup wizard rather than the maintainance wizard.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||so I need to go to tools/ database backups/ select database and the
device; in my case is file E:/... because you already do the full
backup or all server. I am learning SQL server and for the moment I do
not know scrpts very well so I do not want to do that at the moment.
It is true like this or Do I need to do others manipulations?
Ina

FULL Backup question

Hello everybody,
I am very newbie in sqlserver and I would to ask you a question.
I would like to backup my database through backup wizard and I would
like to automatic it for everyday full backup. What to you think it is
better database maintenance planner or backup wizard.
Could someone help me on that?
inaIf you are only doing a scheduling for a backup, I would use the richer
backup wizard rather than the maintainance wizard.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||so I need to go to tools/ database backups/ select database and the
device; in my case is file E:/... because you already do the full
backup or all server. I am learning SQL server and for the moment I do
not know scrpts very well so I do not want to do that at the moment.
It is true like this or Do I need to do others manipulations?
Ina