Dear All,
If I used a SQL command "Delete" to delete for example 1000 records, can I
get it back after? It is because I executed the delete command and later
found out I need some records back. Thank you for your help.
DarylThere are two options:
1=2E Do a Restore (Perhaps you have a point in time backup of the
database with transaction logs)
2=2E If you capsulated the query in a transaction (which I assume you
didn=B4t) Roll it back with ROLLBACK
HTH, Jens Suessmeyer.|||Daryl
yes, if you are lucky. you have to resort to back up. when did you take last
back up?
If you have taken any back up just prior to you can apply that. Wait I
understand that is not there. so you have to depend on 'Point in time '
Recovery.
BOL Has this: But remember. It will restore back to that particulat time. So
all the oprations after that time are be done manually again. Anyway take
full back up with no_truncate option before doing anything.
To restore to a point in time BOL has this.
Expand a server group, and then expand a server.
Expand Databases, right-click the database, point to All Tasks, and then
click Restore Database.
In Restore as database, type or select the name of the database to restore,
if different from the default.
Click Database.
In the First backup to restore list, click the backup set to restore.
In the Restore list, select the database backup and one or more transaction
logs to restore.
Click Point in time restore, and then type values for Date and Time.
Click the Options tab, and then click Leave database operational. No
additional transaction logs can be restored.
--
search and read for point-in-time;point of failure and related topics before
doing anything
--
Take Preventive measures like using
1) use delete trigger to not to rollback when
@.@.rowcount >1 or some records( if it is practical for you)
2) use trigger to store in history tables if data is so crucial.
Regards
R.D
"Daryl" wrote:
> Dear All,
> If I used a SQL command "Delete" to delete for example 1000 records, can I
> get it back after? It is because I executed the delete command and later
> found out I need some records back. Thank you for your help.
>
> Daryl
>
>
Showing posts with label delete. Show all posts
Showing posts with label delete. Show all posts
Tuesday, March 27, 2012
Can I get back the deleted records
Dear All,
If I used a SQL command "Delete" to delete for example 1000 records, can I
get it back after? It is because I executed the delete command and later
found out I need some records back. Thank you for your help.
Daryl
Daryl,
some 3rd party tools will have this functionality eg Lumigent Log Explorer,
but there's nothing out of the box in SQL Server on a per-table basis. If
nothing else has happened, or if it is important enough, you could do a
point-in-time restore, assuming you have the relevant backup plan, however
in this case you'll lose all data changes made since this time (to all
tables). Another possibility is to do a restore but to a database of another
name, then synchronize the data between the 2 tables.
As an aside, one thing I do is use an explicit transaction before an update
or delete, and issue a commit once I've seen the rowcount, otherwise a
rollback - it has saved me more than once
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql
If I used a SQL command "Delete" to delete for example 1000 records, can I
get it back after? It is because I executed the delete command and later
found out I need some records back. Thank you for your help.
Daryl
Daryl,
some 3rd party tools will have this functionality eg Lumigent Log Explorer,
but there's nothing out of the box in SQL Server on a per-table basis. If
nothing else has happened, or if it is important enough, you could do a
point-in-time restore, assuming you have the relevant backup plan, however
in this case you'll lose all data changes made since this time (to all
tables). Another possibility is to do a restore but to a database of another
name, then synchronize the data between the 2 tables.
As an aside, one thing I do is use an explicit transaction before an update
or delete, and issue a commit once I've seen the rowcount, otherwise a
rollback - it has saved me more than once
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql
Can I get back the deleted records
Dear All,
If I used a SQL command "Delete" to delete for example 1000 records, can I
get it back after? It is because I executed the delete command and later
found out I need some records back. Thank you for your help.
DarylDaryl,
some 3rd party tools will have this functionality eg Lumigent Log Explorer,
but there's nothing out of the box in SQL Server on a per-table basis. If
nothing else has happened, or if it is important enough, you could do a
point-in-time restore, assuming you have the relevant backup plan, however
in this case you'll lose all data changes made since this time (to all
tables). Another possibility is to do a restore but to a database of another
name, then synchronize the data between the 2 tables.
As an aside, one thing I do is use an explicit transaction before an update
or delete, and issue a commit once I've seen the rowcount, otherwise a
rollback - it has saved me more than once
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
If I used a SQL command "Delete" to delete for example 1000 records, can I
get it back after? It is because I executed the delete command and later
found out I need some records back. Thank you for your help.
DarylDaryl,
some 3rd party tools will have this functionality eg Lumigent Log Explorer,
but there's nothing out of the box in SQL Server on a per-table basis. If
nothing else has happened, or if it is important enough, you could do a
point-in-time restore, assuming you have the relevant backup plan, however
in this case you'll lose all data changes made since this time (to all
tables). Another possibility is to do a restore but to a database of another
name, then synchronize the data between the 2 tables.
As an aside, one thing I do is use an explicit transaction before an update
or delete, and issue a commit once I've seen the rowcount, otherwise a
rollback - it has saved me more than once
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Can I get back the deleted records
Dear All,
If I used a SQL command "Delete" to delete for example 1000 records, can I
get it back after? It is because I executed the delete command and later
found out I need some records back. Thank you for your help.
DarylDaryl,
some 3rd party tools will have this functionality eg Lumigent Log Explorer,
but there's nothing out of the box in SQL Server on a per-table basis. If
nothing else has happened, or if it is important enough, you could do a
point-in-time restore, assuming you have the relevant backup plan, however
in this case you'll lose all data changes made since this time (to all
tables). Another possibility is to do a restore but to a database of another
name, then synchronize the data between the 2 tables.
As an aside, one thing I do is use an explicit transaction before an update
or delete, and issue a commit once I've seen the rowcount, otherwise a
rollback - it has saved me more than once :)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
If I used a SQL command "Delete" to delete for example 1000 records, can I
get it back after? It is because I executed the delete command and later
found out I need some records back. Thank you for your help.
DarylDaryl,
some 3rd party tools will have this functionality eg Lumigent Log Explorer,
but there's nothing out of the box in SQL Server on a per-table basis. If
nothing else has happened, or if it is important enough, you could do a
point-in-time restore, assuming you have the relevant backup plan, however
in this case you'll lose all data changes made since this time (to all
tables). Another possibility is to do a restore but to a database of another
name, then synchronize the data between the 2 tables.
As an aside, one thing I do is use an explicit transaction before an update
or delete, and issue a commit once I've seen the rowcount, otherwise a
rollback - it has saved me more than once :)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thursday, March 22, 2012
Can I delete Transaction log on subscriber
Hi,
One of our subscriber server is full due to transaction
log too large. The replication was failed without no
space for the transaction log. My question is can I
delete the transation log? Or is there any way I can free
some space on that subscriber server? Please help me.
p.s. we do full backup on our publisher server every day.
Thanks,
While you can delete it I would urge you not to do this. By shutting down
SQL Server and deleting the actual log physical file is a bad idea, although
in some people have claimed to be able to do it, I have never been able to.
I hope you mean truncating it and perhaps shrinking the log file. This is a
better option.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Ping" <anonymous@.discussions.microsoft.com> wrote in message
news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
> Hi,
> One of our subscriber server is full due to transaction
> log too large. The replication was failed without no
> space for the transaction log. My question is can I
> delete the transation log? Or is there any way I can free
> some space on that subscriber server? Please help me.
> p.s. we do full backup on our publisher server every day.
> Thanks,
|||Hi hilary,
Thanks for your reply.
Regarding truncating and shrinking, which one do you
recommend?
Tks
>--Original Message--
>While you can delete it I would urge you not to do this.
By shutting down
>SQL Server and deleting the actual log physical file is a
bad idea, although
>in some people have claimed to be able to do it, I have
never been able to.
>I hope you mean truncating it and perhaps shrinking the
log file. This is a
>better option.
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>"Ping" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
free[vbcol=seagreen]
day.
>
>.
>
One of our subscriber server is full due to transaction
log too large. The replication was failed without no
space for the transaction log. My question is can I
delete the transation log? Or is there any way I can free
some space on that subscriber server? Please help me.
p.s. we do full backup on our publisher server every day.
Thanks,
While you can delete it I would urge you not to do this. By shutting down
SQL Server and deleting the actual log physical file is a bad idea, although
in some people have claimed to be able to do it, I have never been able to.
I hope you mean truncating it and perhaps shrinking the log file. This is a
better option.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Ping" <anonymous@.discussions.microsoft.com> wrote in message
news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
> Hi,
> One of our subscriber server is full due to transaction
> log too large. The replication was failed without no
> space for the transaction log. My question is can I
> delete the transation log? Or is there any way I can free
> some space on that subscriber server? Please help me.
> p.s. we do full backup on our publisher server every day.
> Thanks,
|||Hi hilary,
Thanks for your reply.
Regarding truncating and shrinking, which one do you
recommend?
Tks
>--Original Message--
>While you can delete it I would urge you not to do this.
By shutting down
>SQL Server and deleting the actual log physical file is a
bad idea, although
>in some people have claimed to be able to do it, I have
never been able to.
>I hope you mean truncating it and perhaps shrinking the
log file. This is a
>better option.
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>"Ping" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
free[vbcol=seagreen]
day.
>
>.
>
Can I delete the gather logs?
The gather logs are huge, full of mostly "success" messages, and are
massively slowing down our FT population time. Can I safely delete
them?
Absolutely, but something is wrong here. I think you are in debug mode.
Have a look at the following key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000800005
- replacing SQL0000800005 with your actual catalog name. Make sure the
value of the logsuccesses key is 0.
If it isn't set it to 0 and restart MSSearch.
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174065973.703142.140190@.n76g2000hsh.googlegr oups.com...
> The gather logs are huge, full of mostly "success" messages, and are
> massively slowing down our FT population time. Can I safely delete
> them?
>
|||It was already zero ...
On Mar 16, 12:10 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> Absolutely, but something is wrong here. I think you are in debug mode.
> Have a look at the following key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000800005
> - replacing SQL0000800005 with your actual catalog name. Make sure the
> value of the logsuccesses key is 0.
> If it isn't set it to 0 and restart MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Optiontrader1138" <seoconsultan...@.gmail.com> wrote in message
> news:1174065973.703142.140190@.n76g2000hsh.googlegr oups.com...
|||I stopped the FT service, deleted the main gather log and created an
empty file with the same filename. I then restarted the FT service. It
should've started where it left off, but it doesn't appear that's
happening.
The catalog was initially "idle", which I don't understand. It is set
to "change tracking in background", so I would have assumed it would
start automatically. But it didn't. I kicked off an incremental
population, and it appears that it's started over from the beginning.
In Perf Monitor, the "documents filtered" monitor is currently 0,
while "Waiting documents" is steadily climbing. The new gather file is
already at 627Mb and climbing.
This doesn't seem right. Any ideas?
On Mar 16, 12:25 pm, "Optiontrader1138" <seoconsultan...@.gmail.com>
wrote:[vbcol=seagreen]
> It was already zero ...
> On Mar 16, 12:10 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>
>
>
>
|||You should have left it with change tracking. When it is idle it means it
has finished populating/indexing.
You did not need to re-create the gatherer log. I am still a little puzzled
as to why it is giving you all these status messages.
Could you attach the gatherer log here or email it to me offline. Don't post
it as it is hard for me to interpret all the hex.
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174070015.812532.3280@.y66g2000hsf.googlegrou ps.com...
>I stopped the FT service, deleted the main gather log and created an
> empty file with the same filename. I then restarted the FT service. It
> should've started where it left off, but it doesn't appear that's
> happening.
> The catalog was initially "idle", which I don't understand. It is set
> to "change tracking in background", so I would have assumed it would
> start automatically. But it didn't. I kicked off an incremental
> population, and it appears that it's started over from the beginning.
> In Perf Monitor, the "documents filtered" monitor is currently 0,
> while "Waiting documents" is steadily climbing. The new gather file is
> already at 627Mb and climbing.
> This doesn't seem right. Any ideas?
>
> On Mar 16, 12:25 pm, "Optiontrader1138" <seoconsultan...@.gmail.com>
> wrote:
>
|||As much as I would love to send you the gather log, it is currently
1.17 Gb, so I don't think you'd appreciate me sending it!
"Change tracking in background" is still on. I checked the table and
it definitely was not finished populating when it was idle ... 90% of
the DB was still not indexed and was not showing up in my test
queries.
I think part of the confusion may be that the registry key that you
mentioned may only affect the notifier gather log (in my case, named
SQL0001200005.Ntfy1.gthr). This logfile is only 1k. The 1.17Gb file is
named SQL0001200005.Crwl2.gthr. This is just based on what I've been
able to google so far - let me know if I'm way off-base.
Thanks!!
On Mar 16, 12:51 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> You should have left it with change tracking. When it is idle it means it
> has finished populating/indexing.
> You did not need to re-create the gatherer log. I am still a little puzzled
> as to why it is giving you all these status messages.
> Could you attach the gatherer log here or email it to me offline. Don't post
> it as it is hard for me to interpret all the hex.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Optiontrader1138" <seoconsultan...@.gmail.com> wrote in message
> news:1174070015.812532.3280@.y66g2000hsf.googlegrou ps.com...
>
>
>
>
>
>
|||Can you export the registry key for this catalog and post it here?
Do other catalog exhibit the same behavior?
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174071790.211949.76010@.l75g2000hse.googlegro ups.com...
> As much as I would love to send you the gather log, it is currently
> 1.17 Gb, so I don't think you'd appreciate me sending it!
> "Change tracking in background" is still on. I checked the table and
> it definitely was not finished populating when it was idle ... 90% of
> the DB was still not indexed and was not showing up in my test
> queries.
> I think part of the confusion may be that the registry key that you
> mentioned may only affect the notifier gather log (in my case, named
> SQL0001200005.Ntfy1.gthr). This logfile is only 1k. The 1.17Gb file is
> named SQL0001200005.Crwl2.gthr. This is just based on what I've been
> able to google so far - let me know if I'm way off-base.
> Thanks!!
> On Mar 16, 12:51 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>
|||Sure - here it is:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005]
"LogDirectory"="E:\\SQLData\\SQL0001200005"
"StreamLogsDirectory"="D:\\Program Files\\Microsoft SQL Server\\MSSQL\
\FTData\\SQLServer\\GatherLogs"
"LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Ntfy1.gthr"
"LogNumber"=dword:00000001
"NotificationLogCheckPoint"=hex:80,00,00,00,00,00, 00,00
"HistoryHashMapFile"="E:\\SQLData\\SQL00012000 05\
\SQL0001200005.Hash.gthr"
"DocIdMapFile"="E:\\SQLData\\SQL0001200005\\SQL000 1200005.Idm.gthr"
"NewCrawlNumber"=dword:00000003
"LogSuccess"=dword:00000000
"FollowComplexUrls"=dword:00000000
"DisableRecovery"=dword:00000000
"DisableRobotsExclusion"=dword:00000000
"NormalizeUrls"=dword:00000001
"CaseSensitiveUrls"=dword:00000000
"UseIncrementalCrawlDirIter"=dword:00000000
"ACContentSync"=dword:0000005a
"ACRejects"=dword:00000000
"ACTotal"=dword:00000000
"ACErrorEst"=dword:ffffffff
"ACErrors"=dword:00000000
"ACErrorSamples"=dword:00000000
"ACMaxNoAccess"=dword:00127500
"FilterAlways"=dword:00000000
"LazyCheckPointUpdateInterval"=dword:00015180
"EnableCheckPoint"=dword:00000000
"ACActiveProfile"=hex:ed,58,81,3c,ed,58,81,3c,ed,5 8,81,3c,ed,
58,81,3c,ed,58,81,\
3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c ,ed,58,81,3c,ed,
58,81,3c,\
ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed ,58,81,3c,ed,
58,81,3c,ed,\
58,81,3c,ed,58,81,3c,33,33,33,3f,
00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00,00,00
"ACTrainingProfile"=hex:c6,89,29,34,c6,89,29,34,c6 ,89,29,34,c6,89,29,34,c6,89,\
29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29 ,34,c6,89,29,34,c6,89,29,\
34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34 ,c6,89,29,34,c6,89,29,34,\
c6,89,29,34,c6,89,29,34,8a,e1,ea,
36,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00,00,00,00
"LogExcluded"=dword:00000000
"LogDisabled"=dword:00000000
"ForceFullCrawl"=dword:00000000
"PausedExternal"=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Crawls]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Crawls\2]
"CrawlType"=dword:00000002
"InProgress"=dword:00000001
"DoneAddingCrawlSeeds"=dword:00000001
"LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Crwl2.gthr"
"CheckPoint"=hex:80,00,00,00,00,00,00,00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Extensions]
"IncludedExtensions"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Extensions\ExtensionList]
"0"="htm"
"1"="html"
"2"="txt"
"3"="asp"
"4"="xls"
"5"="doc"
"6"="ppt"
"7"="exch"
"8"="xml"
"9"="eml"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Mappings]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\File]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\File\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="MSSearch.FileHandler.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\Http]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\Http\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="MSSearch.HttpHandler.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\MSSQL75]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\MSSQL75\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="sqlfth75.sqlfth75.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\OleDb]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\OleDb\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="MSSearch.OleDbHandler.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Sites]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\StartPages]
"NewStartPageIdentifier"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\StartPages\0]
"URL"="MSSQL75://SQLServer/77bfcb91"
"HostDepth"=dword:00000000
"EnumerationDepth"=dword:ffffffff
"FollowDirectories"=dword:00000001
"StartPageIdentifier"=dword:00000000
"CrawlNumberInProgress"=dword:00000002
"CrawlNumberScheduled"=dword:ffffffff
"ForceFullCrawl"=dword:00000000
"LastCrawlStopped"=dword:00000000
"Type"=dword:00000002
"CrawlControl"=dword:00000000
"LastCrawlType"=dword:00000002
"IncludeInProjectCrawls"=dword:00000001
"LastCrawlTime"=hex:86,05,c1,a7,f8,67,c7,01
"NotificationHRes"=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\StreamLog]
"CurrentStreamLog"=dword:00000004
"MaxLogs"=dword:00000005
"StreamLogCount"=dword:00000003
|||It looks good. I am not sure what is going on, other than to say this looks
abnormal.
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174073637.792740.132220@.o5g2000hsb.googlegro ups.com...
> Sure - here it is:
> Windows Registry Editor Version 5.00
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005]
> "LogDirectory"="E:\\SQLData\\SQL0001200005"
> "StreamLogsDirectory"="D:\\Program Files\\Microsoft SQL Server\\MSSQL\
> \FTData\\SQLServer\\GatherLogs"
> "LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Ntfy1.gthr"
> "LogNumber"=dword:00000001
> "NotificationLogCheckPoint"=hex:80,00,00,00,00,00, 00,00
> "HistoryHashMapFile"="E:\\SQLData\\SQL00012000 05\
> \SQL0001200005.Hash.gthr"
> "DocIdMapFile"="E:\\SQLData\\SQL0001200005\\SQL000 1200005.Idm.gthr"
> "NewCrawlNumber"=dword:00000003
> "LogSuccess"=dword:00000000
> "FollowComplexUrls"=dword:00000000
> "DisableRecovery"=dword:00000000
> "DisableRobotsExclusion"=dword:00000000
> "NormalizeUrls"=dword:00000001
> "CaseSensitiveUrls"=dword:00000000
> "UseIncrementalCrawlDirIter"=dword:00000000
> "ACContentSync"=dword:0000005a
> "ACRejects"=dword:00000000
> "ACTotal"=dword:00000000
> "ACErrorEst"=dword:ffffffff
> "ACErrors"=dword:00000000
> "ACErrorSamples"=dword:00000000
> "ACMaxNoAccess"=dword:00127500
> "FilterAlways"=dword:00000000
> "LazyCheckPointUpdateInterval"=dword:00015180
> "EnableCheckPoint"=dword:00000000
> "ACActiveProfile"=hex:ed,58,81,3c,ed,58,81,3c,ed,5 8,81,3c,ed,
> 58,81,3c,ed,58,81,\
> 3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c ,ed,58,81,3c,ed,
> 58,81,3c,\
> ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed ,58,81,3c,ed,
> 58,81,3c,ed,\
> 58,81,3c,ed,58,81,3c,33,33,33,3f,
> 00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
> 00,00,00,00,00,00
> "ACTrainingProfile"=hex:c6,89,29,34,c6,89,29,34,c6 ,89,29,34,c6,89,29,34,c6,89,\
> 29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29 ,34,c6,89,29,34,c6,89,29,\
> 34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34 ,c6,89,29,34,c6,89,29,34,\
> c6,89,29,34,c6,89,29,34,8a,e1,ea,
> 36,00,00,00,00,00,00,00,00,00,00,00,00,00,\
> 00,00,00,00,00,00,00
> "LogExcluded"=dword:00000000
> "LogDisabled"=dword:00000000
> "ForceFullCrawl"=dword:00000000
> "PausedExternal"=dword:00000000
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Crawls]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Crawls\2]
> "CrawlType"=dword:00000002
> "InProgress"=dword:00000001
> "DoneAddingCrawlSeeds"=dword:00000001
> "LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Crwl2.gthr"
> "CheckPoint"=hex:80,00,00,00,00,00,00,00
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Extensions]
> "IncludedExtensions"=dword:00000001
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Extensions\ExtensionList]
> "0"="htm"
> "1"="html"
> "2"="txt"
> "3"="asp"
> "4"="xls"
> "5"="doc"
> "6"="ppt"
> "7"="exch"
> "8"="xml"
> "9"="eml"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Mappings]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\File]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\File\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="MSSearch.FileHandler.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\Http]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\Http\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="MSSearch.HttpHandler.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\MSSQL75]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\MSSQL75\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="sqlfth75.sqlfth75.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\OleDb]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\OleDb\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="MSSearch.OleDbHandler.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Sites]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\StartPages]
> "NewStartPageIdentifier"=dword:00000001
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\StartPages\0]
> "URL"="MSSQL75://SQLServer/77bfcb91"
> "HostDepth"=dword:00000000
> "EnumerationDepth"=dword:ffffffff
> "FollowDirectories"=dword:00000001
> "StartPageIdentifier"=dword:00000000
> "CrawlNumberInProgress"=dword:00000002
> "CrawlNumberScheduled"=dword:ffffffff
> "ForceFullCrawl"=dword:00000000
> "LastCrawlStopped"=dword:00000000
> "Type"=dword:00000002
> "CrawlControl"=dword:00000000
> "LastCrawlType"=dword:00000002
> "IncludeInProjectCrawls"=dword:00000001
> "LastCrawlTime"=hex:86,05,c1,a7,f8,67,c7,01
> "NotificationHRes"=dword:00000000
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\StreamLog]
> "CurrentStreamLog"=dword:00000004
> "MaxLogs"=dword:00000005
> "StreamLogCount"=dword:00000003
>
massively slowing down our FT population time. Can I safely delete
them?
Absolutely, but something is wrong here. I think you are in debug mode.
Have a look at the following key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000800005
- replacing SQL0000800005 with your actual catalog name. Make sure the
value of the logsuccesses key is 0.
If it isn't set it to 0 and restart MSSearch.
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174065973.703142.140190@.n76g2000hsh.googlegr oups.com...
> The gather logs are huge, full of mostly "success" messages, and are
> massively slowing down our FT population time. Can I safely delete
> them?
>
|||It was already zero ...
On Mar 16, 12:10 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> Absolutely, but something is wrong here. I think you are in debug mode.
> Have a look at the following key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000800005
> - replacing SQL0000800005 with your actual catalog name. Make sure the
> value of the logsuccesses key is 0.
> If it isn't set it to 0 and restart MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Optiontrader1138" <seoconsultan...@.gmail.com> wrote in message
> news:1174065973.703142.140190@.n76g2000hsh.googlegr oups.com...
|||I stopped the FT service, deleted the main gather log and created an
empty file with the same filename. I then restarted the FT service. It
should've started where it left off, but it doesn't appear that's
happening.
The catalog was initially "idle", which I don't understand. It is set
to "change tracking in background", so I would have assumed it would
start automatically. But it didn't. I kicked off an incremental
population, and it appears that it's started over from the beginning.
In Perf Monitor, the "documents filtered" monitor is currently 0,
while "Waiting documents" is steadily climbing. The new gather file is
already at 627Mb and climbing.
This doesn't seem right. Any ideas?
On Mar 16, 12:25 pm, "Optiontrader1138" <seoconsultan...@.gmail.com>
wrote:[vbcol=seagreen]
> It was already zero ...
> On Mar 16, 12:10 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>
>
>
>
|||You should have left it with change tracking. When it is idle it means it
has finished populating/indexing.
You did not need to re-create the gatherer log. I am still a little puzzled
as to why it is giving you all these status messages.
Could you attach the gatherer log here or email it to me offline. Don't post
it as it is hard for me to interpret all the hex.
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174070015.812532.3280@.y66g2000hsf.googlegrou ps.com...
>I stopped the FT service, deleted the main gather log and created an
> empty file with the same filename. I then restarted the FT service. It
> should've started where it left off, but it doesn't appear that's
> happening.
> The catalog was initially "idle", which I don't understand. It is set
> to "change tracking in background", so I would have assumed it would
> start automatically. But it didn't. I kicked off an incremental
> population, and it appears that it's started over from the beginning.
> In Perf Monitor, the "documents filtered" monitor is currently 0,
> while "Waiting documents" is steadily climbing. The new gather file is
> already at 627Mb and climbing.
> This doesn't seem right. Any ideas?
>
> On Mar 16, 12:25 pm, "Optiontrader1138" <seoconsultan...@.gmail.com>
> wrote:
>
|||As much as I would love to send you the gather log, it is currently
1.17 Gb, so I don't think you'd appreciate me sending it!
"Change tracking in background" is still on. I checked the table and
it definitely was not finished populating when it was idle ... 90% of
the DB was still not indexed and was not showing up in my test
queries.
I think part of the confusion may be that the registry key that you
mentioned may only affect the notifier gather log (in my case, named
SQL0001200005.Ntfy1.gthr). This logfile is only 1k. The 1.17Gb file is
named SQL0001200005.Crwl2.gthr. This is just based on what I've been
able to google so far - let me know if I'm way off-base.
Thanks!!
On Mar 16, 12:51 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> You should have left it with change tracking. When it is idle it means it
> has finished populating/indexing.
> You did not need to re-create the gatherer log. I am still a little puzzled
> as to why it is giving you all these status messages.
> Could you attach the gatherer log here or email it to me offline. Don't post
> it as it is hard for me to interpret all the hex.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Optiontrader1138" <seoconsultan...@.gmail.com> wrote in message
> news:1174070015.812532.3280@.y66g2000hsf.googlegrou ps.com...
>
>
>
>
>
>
|||Can you export the registry key for this catalog and post it here?
Do other catalog exhibit the same behavior?
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174071790.211949.76010@.l75g2000hse.googlegro ups.com...
> As much as I would love to send you the gather log, it is currently
> 1.17 Gb, so I don't think you'd appreciate me sending it!
> "Change tracking in background" is still on. I checked the table and
> it definitely was not finished populating when it was idle ... 90% of
> the DB was still not indexed and was not showing up in my test
> queries.
> I think part of the confusion may be that the registry key that you
> mentioned may only affect the notifier gather log (in my case, named
> SQL0001200005.Ntfy1.gthr). This logfile is only 1k. The 1.17Gb file is
> named SQL0001200005.Crwl2.gthr. This is just based on what I've been
> able to google so far - let me know if I'm way off-base.
> Thanks!!
> On Mar 16, 12:51 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>
|||Sure - here it is:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005]
"LogDirectory"="E:\\SQLData\\SQL0001200005"
"StreamLogsDirectory"="D:\\Program Files\\Microsoft SQL Server\\MSSQL\
\FTData\\SQLServer\\GatherLogs"
"LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Ntfy1.gthr"
"LogNumber"=dword:00000001
"NotificationLogCheckPoint"=hex:80,00,00,00,00,00, 00,00
"HistoryHashMapFile"="E:\\SQLData\\SQL00012000 05\
\SQL0001200005.Hash.gthr"
"DocIdMapFile"="E:\\SQLData\\SQL0001200005\\SQL000 1200005.Idm.gthr"
"NewCrawlNumber"=dword:00000003
"LogSuccess"=dword:00000000
"FollowComplexUrls"=dword:00000000
"DisableRecovery"=dword:00000000
"DisableRobotsExclusion"=dword:00000000
"NormalizeUrls"=dword:00000001
"CaseSensitiveUrls"=dword:00000000
"UseIncrementalCrawlDirIter"=dword:00000000
"ACContentSync"=dword:0000005a
"ACRejects"=dword:00000000
"ACTotal"=dword:00000000
"ACErrorEst"=dword:ffffffff
"ACErrors"=dword:00000000
"ACErrorSamples"=dword:00000000
"ACMaxNoAccess"=dword:00127500
"FilterAlways"=dword:00000000
"LazyCheckPointUpdateInterval"=dword:00015180
"EnableCheckPoint"=dword:00000000
"ACActiveProfile"=hex:ed,58,81,3c,ed,58,81,3c,ed,5 8,81,3c,ed,
58,81,3c,ed,58,81,\
3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c ,ed,58,81,3c,ed,
58,81,3c,\
ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed ,58,81,3c,ed,
58,81,3c,ed,\
58,81,3c,ed,58,81,3c,33,33,33,3f,
00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00,00,00
"ACTrainingProfile"=hex:c6,89,29,34,c6,89,29,34,c6 ,89,29,34,c6,89,29,34,c6,89,\
29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29 ,34,c6,89,29,34,c6,89,29,\
34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34 ,c6,89,29,34,c6,89,29,34,\
c6,89,29,34,c6,89,29,34,8a,e1,ea,
36,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00,00,00,00
"LogExcluded"=dword:00000000
"LogDisabled"=dword:00000000
"ForceFullCrawl"=dword:00000000
"PausedExternal"=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Crawls]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Crawls\2]
"CrawlType"=dword:00000002
"InProgress"=dword:00000001
"DoneAddingCrawlSeeds"=dword:00000001
"LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Crwl2.gthr"
"CheckPoint"=hex:80,00,00,00,00,00,00,00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Extensions]
"IncludedExtensions"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Extensions\ExtensionList]
"0"="htm"
"1"="html"
"2"="txt"
"3"="asp"
"4"="xls"
"5"="doc"
"6"="ppt"
"7"="exch"
"8"="xml"
"9"="eml"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Mappings]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\File]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\File\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="MSSearch.FileHandler.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\Http]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\Http\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="MSSearch.HttpHandler.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\MSSQL75]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\MSSQL75\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="sqlfth75.sqlfth75.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\OleDb]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Protocols\OleDb\0]
"Included"=dword:00000001
"ExtExclusionsUsed"=dword:00000001
"PrefixName"=""
"ProgIdHandler"="MSSearch.OleDbHandler.1"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\Sites]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\StartPages]
"NewStartPageIdentifier"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\StartPages\0]
"URL"="MSSQL75://SQLServer/77bfcb91"
"HostDepth"=dword:00000000
"EnumerationDepth"=dword:ffffffff
"FollowDirectories"=dword:00000001
"StartPageIdentifier"=dword:00000000
"CrawlNumberInProgress"=dword:00000002
"CrawlNumberScheduled"=dword:ffffffff
"ForceFullCrawl"=dword:00000000
"LastCrawlStopped"=dword:00000000
"Type"=dword:00000002
"CrawlControl"=dword:00000000
"LastCrawlType"=dword:00000002
"IncludeInProjectCrawls"=dword:00000001
"LastCrawlTime"=hex:86,05,c1,a7,f8,67,c7,01
"NotificationHRes"=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
\SQL0001200005\StreamLog]
"CurrentStreamLog"=dword:00000004
"MaxLogs"=dword:00000005
"StreamLogCount"=dword:00000003
|||It looks good. I am not sure what is going on, other than to say this looks
abnormal.
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
"Optiontrader1138" <seoconsultant12@.gmail.com> wrote in message
news:1174073637.792740.132220@.o5g2000hsb.googlegro ups.com...
> Sure - here it is:
> Windows Registry Editor Version 5.00
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005]
> "LogDirectory"="E:\\SQLData\\SQL0001200005"
> "StreamLogsDirectory"="D:\\Program Files\\Microsoft SQL Server\\MSSQL\
> \FTData\\SQLServer\\GatherLogs"
> "LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Ntfy1.gthr"
> "LogNumber"=dword:00000001
> "NotificationLogCheckPoint"=hex:80,00,00,00,00,00, 00,00
> "HistoryHashMapFile"="E:\\SQLData\\SQL00012000 05\
> \SQL0001200005.Hash.gthr"
> "DocIdMapFile"="E:\\SQLData\\SQL0001200005\\SQL000 1200005.Idm.gthr"
> "NewCrawlNumber"=dword:00000003
> "LogSuccess"=dword:00000000
> "FollowComplexUrls"=dword:00000000
> "DisableRecovery"=dword:00000000
> "DisableRobotsExclusion"=dword:00000000
> "NormalizeUrls"=dword:00000001
> "CaseSensitiveUrls"=dword:00000000
> "UseIncrementalCrawlDirIter"=dword:00000000
> "ACContentSync"=dword:0000005a
> "ACRejects"=dword:00000000
> "ACTotal"=dword:00000000
> "ACErrorEst"=dword:ffffffff
> "ACErrors"=dword:00000000
> "ACErrorSamples"=dword:00000000
> "ACMaxNoAccess"=dword:00127500
> "FilterAlways"=dword:00000000
> "LazyCheckPointUpdateInterval"=dword:00015180
> "EnableCheckPoint"=dword:00000000
> "ACActiveProfile"=hex:ed,58,81,3c,ed,58,81,3c,ed,5 8,81,3c,ed,
> 58,81,3c,ed,58,81,\
> 3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c ,ed,58,81,3c,ed,
> 58,81,3c,\
> ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed,58,81,3c,ed ,58,81,3c,ed,
> 58,81,3c,ed,\
> 58,81,3c,ed,58,81,3c,33,33,33,3f,
> 00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
> 00,00,00,00,00,00
> "ACTrainingProfile"=hex:c6,89,29,34,c6,89,29,34,c6 ,89,29,34,c6,89,29,34,c6,89,\
> 29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29 ,34,c6,89,29,34,c6,89,29,\
> 34,c6,89,29,34,c6,89,29,34,c6,89,29,34,c6,89,29,34 ,c6,89,29,34,c6,89,29,34,\
> c6,89,29,34,c6,89,29,34,8a,e1,ea,
> 36,00,00,00,00,00,00,00,00,00,00,00,00,00,\
> 00,00,00,00,00,00,00
> "LogExcluded"=dword:00000000
> "LogDisabled"=dword:00000000
> "ForceFullCrawl"=dword:00000000
> "PausedExternal"=dword:00000000
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Crawls]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Crawls\2]
> "CrawlType"=dword:00000002
> "InProgress"=dword:00000001
> "DoneAddingCrawlSeeds"=dword:00000001
> "LogName"="E:\\SQLData\\SQL0001200005\\SQL00012000 05.Crwl2.gthr"
> "CheckPoint"=hex:80,00,00,00,00,00,00,00
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Extensions]
> "IncludedExtensions"=dword:00000001
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Extensions\ExtensionList]
> "0"="htm"
> "1"="html"
> "2"="txt"
> "3"="asp"
> "4"="xls"
> "5"="doc"
> "6"="ppt"
> "7"="exch"
> "8"="xml"
> "9"="eml"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Mappings]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\File]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\File\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="MSSearch.FileHandler.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\Http]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\Http\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="MSSearch.HttpHandler.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\MSSQL75]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\MSSQL75\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="sqlfth75.sqlfth75.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\OleDb]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Protocols\OleDb\0]
> "Included"=dword:00000001
> "ExtExclusionsUsed"=dword:00000001
> "PrefixName"=""
> "ProgIdHandler"="MSSearch.OleDbHandler.1"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\Sites]
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\StartPages]
> "NewStartPageIdentifier"=dword:00000001
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\StartPages\0]
> "URL"="MSSQL75://SQLServer/77bfcb91"
> "HostDepth"=dword:00000000
> "EnumerationDepth"=dword:ffffffff
> "FollowDirectories"=dword:00000001
> "StartPageIdentifier"=dword:00000000
> "CrawlNumberInProgress"=dword:00000002
> "CrawlNumberScheduled"=dword:ffffffff
> "ForceFullCrawl"=dword:00000000
> "LastCrawlStopped"=dword:00000000
> "Type"=dword:00000002
> "CrawlControl"=dword:00000000
> "LastCrawlType"=dword:00000002
> "IncludeInProjectCrawls"=dword:00000001
> "LastCrawlTime"=hex:86,05,c1,a7,f8,67,c7,01
> "NotificationHRes"=dword:00000000
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ Gather\SQLServer
> \SQL0001200005\StreamLog]
> "CurrentStreamLog"=dword:00000004
> "MaxLogs"=dword:00000005
> "StreamLogCount"=dword:00000003
>
Can I delete BAK and TRN files?
I have an implementation of SQL Server 2000 with a job to
backup a customer database. The backup works file, but
none of the old backup and transaction files are removed
after each backup, so it is consuming a lot of disk
space. I have BAK and TRN files dating back 3 months.
Before I deleted any of the old files, I wanted to make
sure I am okay to do so. Does anyone know of a problem
with manually most of these files, leaving only the most
recent week or two of backups?
Thanks,
Jason... and if the backups are created by a SQL Server maintenance plan, you can
modify it to have the files older than a specified period removed. It's on
the Complete Backup and Transaction Log Backup tabs respectively, Remove
files older than item.
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:0b4a01c3d932$260faea0$a001280a@.phx.gbl...
> As far as whether deleting the old backup files will do
> any damage to the backup setup (e.g. your maintanance
> plans) is concerned, there is no problem. But you do need
> to make sure that if you ever need them, you can get them
> back (e.g. from your tape backup facility).
> Linchi
> >--Original Message--
> >I have an implementation of SQL Server 2000 with a job to
> >backup a customer database. The backup works file, but
> >none of the old backup and transaction files are removed
> >after each backup, so it is consuming a lot of disk
> >space. I have BAK and TRN files dating back 3 months.
> >Before I deleted any of the old files, I wanted to make
> >sure I am okay to do so. Does anyone know of a problem
> >with manually most of these files, leaving only the most
> >recent week or two of backups?
> >
> >Thanks,
> >
> >Jason
> >.
> >sql
backup a customer database. The backup works file, but
none of the old backup and transaction files are removed
after each backup, so it is consuming a lot of disk
space. I have BAK and TRN files dating back 3 months.
Before I deleted any of the old files, I wanted to make
sure I am okay to do so. Does anyone know of a problem
with manually most of these files, leaving only the most
recent week or two of backups?
Thanks,
Jason... and if the backups are created by a SQL Server maintenance plan, you can
modify it to have the files older than a specified period removed. It's on
the Complete Backup and Transaction Log Backup tabs respectively, Remove
files older than item.
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:0b4a01c3d932$260faea0$a001280a@.phx.gbl...
> As far as whether deleting the old backup files will do
> any damage to the backup setup (e.g. your maintanance
> plans) is concerned, there is no problem. But you do need
> to make sure that if you ever need them, you can get them
> back (e.g. from your tape backup facility).
> Linchi
> >--Original Message--
> >I have an implementation of SQL Server 2000 with a job to
> >backup a customer database. The backup works file, but
> >none of the old backup and transaction files are removed
> >after each backup, so it is consuming a lot of disk
> >space. I have BAK and TRN files dating back 3 months.
> >Before I deleted any of the old files, I wanted to make
> >sure I am okay to do so. Does anyone know of a problem
> >with manually most of these files, leaving only the most
> >recent week or two of backups?
> >
> >Thanks,
> >
> >Jason
> >.
> >sql
Can I delete BAK and TRN files?
I have an implementation of SQL Server 2000 with a job to
backup a customer database. The backup works file, but
none of the old backup and transaction files are removed
after each backup, so it is consuming a lot of disk
space. I have BAK and TRN files dating back 3 months.
Before I deleted any of the old files, I wanted to make
sure I am okay to do so. Does anyone know of a problem
with manually most of these files, leaving only the most
recent week or two of backups?
Thanks,
JasonAs far as whether deleting the old backup files will do
any damage to the backup setup (e.g. your maintanance
plans) is concerned, there is no problem. But you do need
to make sure that if you ever need them, you can get them
back (e.g. from your tape backup facility).
Linchi
n
modify it to have the files older than a specified period removed. It's on
the Complete Backup and Transaction Log Backup tabs respectively, Remove
files older than item.
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:0b4a01c3d932$260faea0$a001280a@.phx.gbl...[QUOTE]
> As far as whether deleting the old backup files will do
> any damage to the backup setup (e.g. your maintanance
> plans) is concerned, there is no problem. But you do need
> to make sure that if you ever need them, you can get them
> back (e.g. from your tape backup facility).
> Linchi
>
backup a customer database. The backup works file, but
none of the old backup and transaction files are removed
after each backup, so it is consuming a lot of disk
space. I have BAK and TRN files dating back 3 months.
Before I deleted any of the old files, I wanted to make
sure I am okay to do so. Does anyone know of a problem
with manually most of these files, leaving only the most
recent week or two of backups?
Thanks,
JasonAs far as whether deleting the old backup files will do
any damage to the backup setup (e.g. your maintanance
plans) is concerned, there is no problem. But you do need
to make sure that if you ever need them, you can get them
back (e.g. from your tape backup facility).
Linchi
quote:|||... and if the backups are created by a SQL Server maintenance plan, you ca
>--Original Message--
>I have an implementation of SQL Server 2000 with a job to
>backup a customer database. The backup works file, but
>none of the old backup and transaction files are removed
>after each backup, so it is consuming a lot of disk
>space. I have BAK and TRN files dating back 3 months.
>Before I deleted any of the old files, I wanted to make
>sure I am okay to do so. Does anyone know of a problem
>with manually most of these files, leaving only the most
>recent week or two of backups?
>Thanks,
>Jason
>.
>
n
modify it to have the files older than a specified period removed. It's on
the Complete Backup and Transaction Log Backup tabs respectively, Remove
files older than item.
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:0b4a01c3d932$260faea0$a001280a@.phx.gbl...[QUOTE]
> As far as whether deleting the old backup files will do
> any damage to the backup setup (e.g. your maintanance
> plans) is concerned, there is no problem. But you do need
> to make sure that if you ever need them, you can get them
> back (e.g. from your tape backup facility).
> Linchi
>
Can I delete a DB and add it back under same name?
Are there any "cleaning" issues I should know about if I delete a database
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?
drop database <db>
should delete it from sql catalog and remove the data file from disk.
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>
|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
database[vbcol=seagreen]
file?
>
|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah
|||The only thing I can think of is backup history in the msdb database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> database
> file?
>
|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?
drop database <db>
should delete it from sql catalog and remove the data file from disk.
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>
|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
database[vbcol=seagreen]
file?
>
|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah
|||The only thing I can think of is backup history in the msdb database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> database
> file?
>
|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah
Can I delete a DB and add it back under same name?
Are there any "cleaning" issues I should know about if I delete a database
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?drop database <db>
should delete it from sql catalog and remove the data file from disk.
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
database[vbcol=seagreen]
file?[vbcol=seagreen]
>|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah|||The only thing I can think of is backup history in the msdb database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> database
> file?
>|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?drop database <db>
should delete it from sql catalog and remove the data file from disk.
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
database[vbcol=seagreen]
file?[vbcol=seagreen]
>|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah|||The only thing I can think of is backup history in the msdb database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> database
> file?
>|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah
Can I delete a DB and add it back under same name?
Are there any "cleaning" issues I should know about if I delete a database
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?drop database <db>
should delete it from sql catalog and remove the data file from disk.
--
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> > Are there any "cleaning" issues I should know about if I delete a
database
> > in 2005, and then add it back under the same name with a newer .BAK
file?
> > I know how to delete, and how to import a backup, but I don't know if
> > there
> > are suggested cleaning steps between. Anything I should do?
> >
> >
>|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah|||The only thing I can think of is backup history in the msdb database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
>> drop database <db>
>> should delete it from sql catalog and remove the data file from disk.
>> --
>> -oj
>>
>> "HK" <replywithingroup@.notreal.com> wrote in message
>> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
>> > Are there any "cleaning" issues I should know about if I delete a
> database
>> > in 2005, and then add it back under the same name with a newer .BAK
> file?
>> > I know how to delete, and how to import a backup, but I don't know if
>> > there
>> > are suggested cleaning steps between. Anything I should do?
>> >
>> >
>>
>|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah
in 2005, and then add it back under the same name with a newer .BAK file?
I know how to delete, and how to import a backup, but I don't know if there
are suggested cleaning steps between. Anything I should do?drop database <db>
should delete it from sql catalog and remove the data file from disk.
--
-oj
"HK" <replywithingroup@.notreal.com> wrote in message
news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> Are there any "cleaning" issues I should know about if I delete a database
> in 2005, and then add it back under the same name with a newer .BAK file?
> I know how to delete, and how to import a backup, but I don't know if
> there
> are suggested cleaning steps between. Anything I should do?
>|||So no extra cleanup steps needed? I imagine there COULD be weird things
left behind.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
> drop database <db>
> should delete it from sql catalog and remove the data file from disk.
> --
> -oj
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
> > Are there any "cleaning" issues I should know about if I delete a
database
> > in 2005, and then add it back under the same name with a newer .BAK
file?
> > I know how to delete, and how to import a backup, but I don't know if
> > there
> > are suggested cleaning steps between. Anything I should do?
> >
> >
>|||Just drop the database it will delete related files.
If database is offline only in that case you have to manually delete
files.
Then restore databse.
Regards
Amish Shah|||The only thing I can think of is backup history in the msdb database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"HK" <replywithingroup@.notreal.com> wrote in message
news:0OHWf.17622$w86.15212@.tornado.socal.rr.com...
> So no extra cleanup steps needed? I imagine there COULD be weird things
> left behind.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u%23lFZ15UGHA.6048@.TK2MSFTNGP11.phx.gbl...
>> drop database <db>
>> should delete it from sql catalog and remove the data file from disk.
>> --
>> -oj
>>
>> "HK" <replywithingroup@.notreal.com> wrote in message
>> news:YBFWf.19819$%d.12971@.tornado.socal.rr.com...
>> > Are there any "cleaning" issues I should know about if I delete a
> database
>> > in 2005, and then add it back under the same name with a newer .BAK
> file?
>> > I know how to delete, and how to import a backup, but I don't know if
>> > there
>> > are suggested cleaning steps between. Anything I should do?
>> >
>> >
>>
>|||when you drop a database through EM it will ask to delete history about
backup and restore.
If you drop database using TSQL you will have to delete history
maually.
Regards
Amish Shah
Monday, March 19, 2012
Can I add records to or delete them from an sql database throught Crystal Report
Hello. I would like to know if its possible to add records to an sql database field or delete from it through Crystal Reports? Basically, I wish to setup a html fill in form configured to crystal reports whereby I can pull out results and then if required I could add or delete any record.
Is this possible?
Please help.I dont think it is possible in CR
See if you find solution here
www.businessobjects.com|||Hello, Madhi. Thank you for your reply to my question (and any other questions I posted on the forum). I have found a way I can add and delete records from crystal reports to an sql database using sql commands and crystal formulas (via the business objects website). But its all very basic stuff as yet - good stuff, nevertheless.
I will look begin to look further into this. Thank you for you help.
Regards
Saf|||saf,
if you can please walk me throught how did you get it from that website. There is no forums or anything right? Thanks|||Here is the link for the Business Objects tutorial that I followed:
http://support.businessobjects.com/library/kbase/articles/c2011950.asp
It works. Please follow up on the link.
Is this possible?
Please help.I dont think it is possible in CR
See if you find solution here
www.businessobjects.com|||Hello, Madhi. Thank you for your reply to my question (and any other questions I posted on the forum). I have found a way I can add and delete records from crystal reports to an sql database using sql commands and crystal formulas (via the business objects website). But its all very basic stuff as yet - good stuff, nevertheless.
I will look begin to look further into this. Thank you for you help.
Regards
Saf|||saf,
if you can please walk me throught how did you get it from that website. There is no forums or anything right? Thanks|||Here is the link for the Business Objects tutorial that I followed:
http://support.businessobjects.com/library/kbase/articles/c2011950.asp
It works. Please follow up on the link.
Subscribe to:
Posts (Atom)