What is a simple command line program or script to backup SQL server databases?

by

To backup a single database from the command line, use osql or sqlcmd.

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe" 
    -E -Q "BACKUP DATABASE mydatabase TO DISK='C:\tmp\db.bak' WITH FORMAT"

You’ll also want to read the documentation on BACKUP and RESTORE and general procedures.

More Related Contents:

  1. In SQL Server, how do I generate a CREATE TABLE statement for a given table?
  2. SQL Server: Database stuck in “Restoring” state
  3. SQL Server backup/restore vs. detach/attach
  4. How do I generate a random number for each row in a T-SQL select?
  5. Auto increment primary key in SQL Server Management Studio 2012
  6. SQL Server Linked Server Example Query
  7. Combine multiple results in a subquery into a single comma-separated value
  8. Infinite loop CTE with OPTION (maxrecursion 0)
  9. SQL Server IN vs. EXISTS Performance
  10. Floor a date in SQL server
  11. How to drop a table if it exists?
  12. PIVOT in sql 2005
  13. How to run the same query on all the databases on an instance?
  14. Atomic UPSERT in SQL Server 2005
  15. How FOR XML PATH(”) works when concatenating rows
  16. Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
  17. SSRS 2014 report deploy issue
  18. Set start value for column with autoincrement
  19. SqlDataAdapter.Fill method slow
  20. What is the Oracle equivalent of SQL Server’s IsNull() function?
  21. SQL Server BCP export corrupted file?
  22. Making an Entity Framework Model span multiple databases
  23. SQL Server 2008 Row Insert and Update timestamps
  24. Full text search does not work if stop word is included even though stop word list is empty
  25. Should I index a bit field in SQL Server?
  26. Setting up maven dependency for SQL Server
  27. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  28. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  29. Escaping single quote in SQL Server
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment