SQL Server - creating a historical data backup
I've run out of space on my SQL Server 2008 Express DB.


Best is to script out the schema using SSMS. Then 


Take a full backup of your database --or--
bcp out the data from the tables. (note: the script will bcp out in native format. Change it to bcp out data in human readable format - by removing -n)