In Oracle there is CREATE TABLE…AS to backup table into a new table and the syntax on SQL Server is a bit different to copy table. So the syntax on SQL Server is

SELECT * INTO newtable FROM sourcetable

Additional documentation from Microsoft
http://msdn.microsoft.com/en-us/library/ms190750.aspx

• General DBA
• SQL Server
• Table