InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:20:59 GMT20http://www.sqlservercentral.com/Forums/Topic822870-357-1.aspx'there is no any listing of 'backup' command or 'restore' command and its parameters.so how can i get all the available commands in sqlcmd.'BACKUP and RESTORE commands are T-SQL commands. T-SQL is the SQL Server programming language. You'll need to go through help files etc. to learn it.For example if you open up SQL Server help and look up BACKUP you'll find help on its syntax.All of the 'available commands in SQLCMD' are exactly the same as the available commands that you use in a query window in SQL Server Management Studio.Wed, 25 Nov 2009 16:49:20 GMTnick.mcdermaidhttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxHi Shyam,You can find lots of good exampls in Books Online. Some of the URLs are :http://msdn.microsoft.com/en-us/library/ms162773.aspxhttp://msdn.microsoft.com/en-us/library/ms165702.aspxhttp://msdn.microsoft.com/en-us/library/ms180944.aspxList of all command prompt utilities:http://msdn.microsoft.com/en-us/library/ms162816.aspxWed, 25 Nov 2009 03:54:53 GMTAtul DBAhttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxhi,thanks for your valuable post.the command is working fine without any modification.can u give me any link that deals with all the available commands in sqlcmd..like how to see in which database i am presently working in,to delete a database, to see description of a table...and so ononce again thanks..Wed, 25 Nov 2009 03:11:04 GMTshyam.oechttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxhi,'sqlcmd /?' command gives the commands that are available in sqlcmd,but there is no any listing of 'backup' command or 'restore' command and its parameters.so how can i get all the available commands in sqlcmd.Wed, 25 Nov 2009 02:59:32 GMTshyam.oechttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxTo get the list of command line switchs for sqlcmd, do what you do for every other command line tool - type this at a command prompt:SQLCMD /?As for the commands that you can submit to SQL through SQLCMD, that is the T-SQL language, which is explained in SQL Server help files.Wed, 25 Nov 2009 01:42:07 GMTnick.mcdermaidhttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxYou can restore the database on other server after moving the backup files.The command prompt is run like this: "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\OSQL.EXE" -E Then write these lines to restore the database: RESTORE DATABASE mydbname from DISK = 'C:\xxx\xxx\xxx.bak' WITH MOVE 'database_Data' to 'C:\Database\xxx\database_Data.mdf', MOVE 'database_Log' to 'C:\Database\xxx\database_Log.LDF' GOYou have to write the correct path for file locations to complete the restoration process.Tue, 24 Nov 2009 05:29:23 GMTAtul DBAhttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxi guess you are new to dba world... i gues you want to restore the backuped database on new server.restore database databasename from disk ='filepath'syntax might be different check Books online.Mon, 23 Nov 2009 22:45:19 GMTramuvanpartihttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxhi,yes,backup is successfully created.now can u help me how to retrieve (or restore) by database to another sql server database?i.e if i send the backup file to another system and there i want to restore the database,then how?can u tell me how to get the help menu in sqlcmd command prompt..where i can get a list of commands in sqlcmd?Mon, 23 Nov 2009 17:08:28 GMTshyam.oechttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxHi Shyam, Please confirm if the problem is fixed now.Mon, 23 Nov 2009 06:15:42 GMTAtul DBAhttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxthanks.Sat, 21 Nov 2009 17:48:45 GMTshyam.oechttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxerror says that you do have access on the c drive..open cmdtype sqlcmd -S"servername" -U"username" -P"password"after successful login you see>11 use master2 backup database dbname to disk=N'c:\foldername\db.bak'3 gothe db backed upcheck the link for more detailsSat, 21 Nov 2009 10:10:57 GMTramuvanpartihttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxthe link you provided is not so fruitful.it did'nt solved my problem.Also ,you gave the commands for backup:backup database databasename to disk='C:\db.bak'.But it too gave errors:Cannot open backup device 'C:\db.bak' Operating system error 5(Access is denied...).BACKUP DATABASE is terminating abnormally.THIS IS THE ERROR MESSAGE I GET IN COMMAND PROMPT OF SQLCMD.PLZ HELPSat, 21 Nov 2009 09:58:07 GMTshyam.oechttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxthe link you provided is not so fruitful.it did'nt solved my problem.Also ,you gave the commands for backup:backup database databasename to disk='C:\db.bak'.But it too gave errors:Cannot open backup device 'C:\db.bak' Operating system error 5(Access is denied...).BACKUP DATABASE is terminating abnormally.THIS IS THE ERROR MESSAGE I GET IN COMMAND PROMPT OF SQLCMD.PLZ HELPSat, 21 Nov 2009 09:55:17 GMTshyam.oechttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxyes,its sql express editionSat, 21 Nov 2009 09:29:49 GMTshyam.oechttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxhttp://msdn.microsoft.com/en-us/library/ms165702(SQL.90).aspxuse this link .it shows to login and then once you login you write normal backup commandbackup database dbname to disk='c:\db.bak'Sat, 21 Nov 2009 06:04:24 GMTramuvanpartihttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxIs your SQL Server is a Express editionSat, 21 Nov 2009 06:01:16 GMTramuvanpartihttp://www.sqlservercentral.com/Forums/Topic822870-357-1.aspxhi,i have installed visual studio 2008, so sql server 2005 is by default installed.can you tell me how to back up my database files through command prompt,sqlcmd :)Sat, 21 Nov 2009 05:44:02 GMTshyam.oec