patternsqlMinor
Backup without using SQL Server Management Studio
Viewed 0 times
withoutsqlmanagementusingstudioserverbackup
Problem
I am trying to take a backup on a Windows Server 2003 and SQL Server 2005 installed on it. But, there is no SQL Server Management Studio on it. How can I take full backup of a particular database.
Solution
You can use sqlcmd from the command prompt.
It's default location for SQL 2012 is here :- C:\Program Files\Microsoft SQL Server\110\Tools\Binn
For windows authentication run :- sqlcmd -SSERVERNAME
or for sql authentication run:- sqlcmd -SSERVERNAME -ULogin -PPassword
You can then run a backup sql statement.
http://msdn.microsoft.com/en-us/library/ms180944.aspx
It's default location for SQL 2012 is here :- C:\Program Files\Microsoft SQL Server\110\Tools\Binn
For windows authentication run :- sqlcmd -SSERVERNAME
or for sql authentication run:- sqlcmd -SSERVERNAME -ULogin -PPassword
You can then run a backup sql statement.
http://msdn.microsoft.com/en-us/library/ms180944.aspx
Context
StackExchange Database Administrators Q#77092, answer score: 3
Revisions (0)
No revisions yet.