I've run out of space on my SQL Server 2008 Express DB.
i'm creating a "duplicate" SQL Server 2008 Express DB so i can backup my data before i purge my DB so i can start over. Is there a way in SQL Server to view the DDL text file, so i can easily recreate the empty table before i push data into it?
Also, is there as "easy" way to bulk push data from one table into another once i've created the backup structure?
at first i tried deleting some old rows, but of course that just increases the log file.