To calculate the lenght of a TEXT field the LEN function used to calculate the length of VARCHAR fields won’t work. You need to use the DATALENGTH T-SQL function: SELECT DATALENGTH(myTextField) AS lengthOfMyTextField
Category: Transact-SQL
MS SQL Backup Database to Disk
To create a full database backup using Transact-SQL Execute the BACKUP DATABASE statement to create the full database backup, specifying: The name of the database to back up. The backup device where the full database backup is written. Example BACKUP DATABASE AdventureWorks TO DISK = ‘C:BackupsAdventureWorks.BAK’