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 |
|
azharrahi
Starting Member
44 Posts |
 Posted - 2007-04-28 : 04:48:28
|
| Hi Hope you all will be fineI want a database query which can take the back up of a particular database (like sp_columns, which produces columns description), because i want to use it on my forms to take back up on button click event.ThanksAzhar RahiSoftware EngineerExperts Desk Pvt Ltd,Lahore Pakistan |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-28 : 04:55:16
|
"I want a database query which can take the back up of a particular database (like sp_columns, which produces columns description)"What do you mean by this ?When you perform a backup of a database, everything (all tables, views, stored procedures, data etc.) in the database will be backup together.
KH |
 |
|
|
azharrahi
Starting Member
44 Posts |
Posted - 2007-04-28 : 06:26:54
|
| Actually this means that ..e.g. If I want to take columns names of a table a stored procedure sp_columns is available.. to which u provide table name and it returns all information of table columns like column name, datatypes etc. i.e sp_columns 'TableName'I hope there must be any built in stored procedure to which if we provide database name it will take the back up ... I know we can take back up on SQL Server 2000 and 2005 . But its not my requirement to take back up directly on SQL Server . I want to run query or stored procedure through User Interface so that no need to open SQL Server 2000 or 2005 to take back up.Azhar RahiSoftware EngineerExperts Desk Pvt Ltd,Lahore Pakistan |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-28 : 06:32:06
|
"I hope there must be any built in stored procedure to which if we provide database name it will take the back up"use the BACKUP DATABASE command
KH |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-28 : 20:47:50
|
| You can use osql or sqlcmd to connect to sql server and run backup statement. |
|
|
|
|
|
|
|
|
Database Backup Query required