Fill stops /timeouts

Dear Group,

I am tring to use a command that calls the server to fill an adapter, it
never seems to get to the adapter, command and the server either times out
or does not respond. The timeout is set at 10 hours. I am using Visual
Studio to acces MS SQL - Server.

I think I have all the rights and permissions set correctly. Also, I have
used this command to fill other adapters and tables.

Does anyone have a suggestion.

Jeff MagouirkJeff Magouirk (magouirkj@.njc.org) writes:
> I am tring to use a command that calls the server to fill an adapter, it
> never seems to get to the adapter, command and the server either times out
> or does not respond. The timeout is set at 10 hours. I am using Visual
> Studio to acces MS SQL - Server.
> I think I have all the rights and permissions set correctly. Also, I have
> used this command to fill other adapters and tables.
> Does anyone have a suggestion.

I am afraid that the amount of detail in your post is too small for a
good answer to be possible.

One trivial reason could be blocking. You can run sp_who to see if you
have any blocking. If there is a non-zero value in th Blk column, then
that process is blocking the spid for this row.

If the query really takes ten hours to run - then you have some tuning
to do!

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

FileGroup

Dear Professional
Can any body tell me give me the URL where there is any good explaination
step by step about the filegroup backup as well restoration process and all
the detail.
Thanks
Noor
Hi Noor,
Have a look into the below sections in books online:-
"Physical Database Files and Filegroups"
"Using Files and Filegroups"
"Creating Filegroups"
"Using File Backups"
"Files and Filegroups"
"Backing up and Restoring Databases"
"Partial Database Restore Operations"
"Backing up Selected Portions of a Database"
Thanks
Hari
MCDBA
"Noorali Issani" <naissani@.softhome.net> wrote in message
news:OghYmaXOEHA.1276@.TK2MSFTNGP11.phx.gbl...
> Dear Professional
> Can any body tell me give me the URL where there is any good explaination
> step by step about the filegroup backup as well restoration process and
all
> the detail.
>
> Thanks
> Noor
>
|||BOL
"Noorali Issani" <naissani@.softhome.net> wrote in message
news:OghYmaXOEHA.1276@.TK2MSFTNGP11.phx.gbl...
> Dear Professional
> Can any body tell me give me the URL where there is any good explaination
> step by step about the filegroup backup as well restoration process and
all
> the detail.
>
> Thanks
> Noor
>

file/filegroup backup vs copy the mdf, ndf, ldf file directly

Dear all,
I have a question about the difference between file/filegroup backup and
copy the mdf, ndf, ldf file directly
1.) If i copy the mdf,ndf,ldf file and then replace the file(recreate the db
with the same name) to the sql server, will it works and ok, what is the
difference with backup file/filegroup backup?
2.) if i backup with sql script backup (select all object), is it the same
output with full backup?1.) The only way to safely copy the files directly is to detach the
database first. That means you must take it off line. A backup does not
require you to take the db offline.
2.) The generate script is simply the DDL to recreate the database and
does not contain the data. It is not to be used in place of a backup.
Andrew J. Kelly SQL MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:299DA939-7562-4546-B4A1-15F7CA2D8881@.microsoft.com...
> Dear all,
> I have a question about the difference between file/filegroup backup and
> copy the mdf, ndf, ldf file directly
> 1.) If i copy the mdf,ndf,ldf file and then replace the file(recreate the
> db
> with the same name) to the sql server, will it works and ok, what is the
> difference with backup file/filegroup backup?
> 2.) if i backup with sql script backup (select all object), is it the same
> output with full backup?
>|||Script backup does not have data?
"Andrew J. Kelly" wrote:

> 1.) The only way to safely copy the files directly is to detach the
> database first. That means you must take it off line. A backup does not
> require you to take the db offline.
> 2.) The generate script is simply the DDL to recreate the database and
> does not contain the data. It is not to be used in place of a backup.
> --
> Andrew J. Kelly SQL MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:299DA939-7562-4546-B4A1-15F7CA2D8881@.microsoft.com...
>
>|||Now I am not sure what you are referring to. There isn't a way to directly
generate a backup script that I know of. Can you explain exactly how you
get to the script?
Andrew J. Kelly SQL MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:786D0922-017D-41AE-A915-63F76799F77E@.microsoft.com...[vbcol=seagreen]
> Script backup does not have data?
> "Andrew J. Kelly" wrote:
>

file Server and Ful text indexing

Dear All,
Is it possible for SQL Server to search on documents which are not inserted
into the database?
for example does SQL Server have the facility to scan the documents, keeping
the documents in the fileserver itself and doing full-text indexing on them
taking only the token words from it. (These token words can be inserted into
database as indexes).
A similar facility is provided bu ORACLE-Text.
We are new to this area. So any hints on this would be advantageous for us.
Very thanks in anticipation.
Also please give us the utilities/tools which are readily available which
can be integrated with SQL Server / .Net Applications for database and
Documents Search.
Regards
SathianSathian,
Yes, but not using SQL Server's "full text search" components, instead you
would use the Indexing Service and create a Linked Server to IS via the
MSIDXS OLE-DB provider. See SQL Server 2000 BOL title's "OLE DB Provider for
Microsoft Indexing Service" and sp_addlinkedserver from more info on this.
Note, while this is functional, it does not perform very well.
I believe that the ORACLE Text (an expensive add-on) feature you're
refereing to is called "Oracle Ultra Search". Correct? This is another "for
fee" spider based service of ORACLE Text, that has no direct feature
comparison in SQL Server 2000 or 2005 Full Text Search, I'm to say...
If you're interested in more details, feel free to email me directly.
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sathian T" <sathian.t@.in.Bosch.com> wrote in message
news:d188gf$itc$1@.ns2.fe.internet.bosch.com...
> Dear All,
> Is it possible for SQL Server to search on documents which are not
inserted
> into the database?
> for example does SQL Server have the facility to scan the documents,
keeping
> the documents in the fileserver itself and doing full-text indexing on
them
> taking only the token words from it. (These token words can be inserted
into
> database as indexes).
> A similar facility is provided bu ORACLE-Text.
> We are new to this area. So any hints on this would be advantageous for
us.
> Very thanks in anticipation.
> Also please give us the utilities/tools which are readily available which
> can be integrated with SQL Server / .Net Applications for database and
> Documents Search.
> Regards
> Sathian
>