Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeer
Starting Member
32 Posts |
 Posted - 2008-03-27 : 04:13:29
|
| hiI want to take the backup of my database. I dont want to use "sql server management studio". Is there any other way for taking backup?Please guide me. Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-03-27 : 05:58:51
|
| see the backup database statement in bol.or thishttp://www.nigelrivett.net/SQLAdmin/BackupDatabase.html>> I dont want to use "sql server management studio". Excellent.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-03-27 : 06:39:26
|
| Actually while connection through SQL Server Management Studion, I get an error. Please tell me any other SQL Server Tools for back and if i use scripts then which tools of sql server should i useregards |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-03-27 : 07:01:49
|
| management studio should be good. You would probably schedule the backup using the agent but you need to get the script working first.What is the error you get?start with backup database mydb to disk = 'c:\mydb.bak'making sure the database and backup path exists.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 23:13:24
|
| You can run sql statement with sqlcmd in dos. |
|
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-03-27 : 23:31:49
|
| While starting sqlcmd in DOS, i got following error:F:\Documents and Settings\Administrator>sqlcmdHResult 0x2, Level 16, State 1Named Pipes Provider: Could not open a connection to SQL Server [2].Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.Please guide me to resolve my problem. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 23:36:19
|
| You have to specify options in sqlcmd, check books online or use 'sqlcmd /?' to get details. |
|
|
|
|
|
|
Backup