Can I EXPORT tables to a backup DB and delete them from my production server?

[war_wheelan]

I have a database file approximately 30GB in size which creates 3 data
tables daily. I need to reduce the size of the DB due to disk size
limitations. Could I EXPORT some tables, let us say over thirty days
old, to something like DB_Name_Archieve and them delete them from the
production DB to reduce the size? I also need the ability to
reference/read them at a later time as needed.

As a side note, could SQL Server use data on a redirected drive i.e.
NET Used. This would allow me to move the old tables to the redirected
drive and reference them as needed.

As always, thanks in advance.

Peter

[Erland Sommarskog]

(wa*********@yahoo.com) writes:

I have a database file approximately 30GB in size which creates 3 data
tables daily.
Hm, normally you are not supposed to create tables daily - rather you
insert to existing tables, and use the date as your key. In this case,
this scheme may work to your advantage.
I need to reduce the size of the DB due to disk size limitations. Could
I EXPORT some tables, let us say over thirty days old, to something like
DB_Name_Archieve and them delete them from the production DB to reduce
the size? I also need the ability to reference/read them at a later
time as needed.
That's really a business issue, that no one from the outside can
answer. Technically, yes, you can. Whether you may, you will have to
ask your boss.

If you put the tables in another database, the application will have
to find its way to that database.
As a side note, could SQL Server use data on a redirected drive i.e.
NET Used. This would allow me to move the old tables to the redirected
drive and reference them as needed.

I think that with some tricks SQL Server can be lured to access
database files on network drives. However, it is completely unsupported
and highly unadvisable to do so.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

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