I have a log file that went out of control (147GB), I feel that doing a shrink on the file/database would be time consuming so I am thinking of recreating the database from an imported version from our test server.
I know that data can flow from one SQL server to another without regard to the SQL server version but can tables, stored procedures and views export from a 2000 database and put back into a 7.0 database?
Thanks
--
Message posted via http://www.sqlmonster.com