archiving tables

We have some fast growing tables in our SQL Server 2000 db
which content 13 million records already. So, we going to
periodically archive them base on datetime field and allow
user to retrieve archive data via our application by
checking corresponding checkbox. The problem is that, we
do not know what to do with FK's. How to re-create FK's
after archiving to restore referal integrity.
Is there some standard solution?
Any comments will be appreciated.
Merry chistmas and happy new year to everybody.Vitalik
http://vyaskn.tripod.com/sql_archive_data.htm
"vitaliyk" <vitaliykrasner@.hotmail.com> wrote in message
news:08ee01c3c964$5faa1340$a401280a@.phx.gbl...
> We have some fast growing tables in our SQL Server 2000 db
> which content 13 million records already. So, we going to
> periodically archive them base on datetime field and allow
> user to retrieve archive data via our application by
> checking corresponding checkbox. The problem is that, we
> do not know what to do with FK's. How to re-create FK's
> after archiving to restore referal integrity.
> Is there some standard solution?
> Any comments will be appreciated.
> Merry chistmas and happy new year to everybody.

Application Event ID 17177

I periodically get the following information from the
application event log:

quote:

---

>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).

---

Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...

quote:

---

> I periodically get the following information from the
> application event log:
>
> Why is this generated? What is the significance of this
> information?
>

---

|||We have a client who is getting the same error except it says a different pr
ocess id. The problem is it is showing up at 12:00 every night when sql ser
ver is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder.
When I view the dat files i
n the directory they are from November, needless to say not current. When I
am in the SQL enterprise manager under management- sql server agent-jobs, I
can see the separate jobs and when I look at the properties they are schedu
led for daily @. 12:00 am.
Why am I not getting updated files in the backup folder? Ntbackup is runni
ng nightly with no errors and is backing up all sql database files along wit
h this MSSQL\Backup folder but the files in it are not current. Ntbackup is
backing up to 4mmtape. An
y help guys would be greatly appreciated.
Phil

Application Event ID 17177

I periodically get the following information from the
application event log:
>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).
Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...
> I periodically get the following information from the
> application event log:
> >This instance of SQL Server has been using a process id
> >of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
> >AM (UTC).
> Why is this generated? What is the significance of this
> information?
>|||We have a client who is getting the same error except it says a different process id. The problem is it is showing up at 12:00 every night when sql server is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder. When I view the dat files in the directory they are from November, needless to say not current. When I am in the SQL enterprise manager under management- sql server agent-jobs, I can see the separate jobs and when I look at the properties they are scheduled for daily @. 12:00 am. Why am I not getting updated files in the backup folder? Ntbackup is running nightly with no errors and is backing up all sql database files along with this MSSQL\Backup folder but the files in it are not current. Ntbackup is backing up to 4mmtape. Any help guys would be greatly appreciated
Phil