Is there any Sql command to Backup and restore sql database?

[anant iyer]

:rose::rose: Hi to all, :confused: please help me i am finding commands to Backup and restore sql database which i will select , from my .Net project directly. :confused::confused::confused::confused::confused::confused::confused::confused::confused: anant -- modified at 3:03 Sunday 19th March, 2006

[Danilo Corallo]

Hi, the only SQL Command I know is this one: The SELECT INTO Statement The SELECT INTO statement is most often used to create backup copies of tables or for archiving records. Syntax SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source Check the w3school website for complete documentation: http://www.w3schools.com/sql/sql\_select\_into.asp With Kind Regards

[Beemen]

backup database database_name to disk='path' Beemen Beshara -- modified at 10:50 Sunday 19th March, 2006

[anant iyer]

hi Beemen, Thanks for helping me, But you didn't give the restore command. I tried the Backup command and it worked, COOL man :cool:. My the faculties never teach me these kinds commands. THANKs anant