T-SQL For BackUp Database - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

T-SQL For BackUp Database

Author

Topic

aravindt77
Posting Yak Master

120 Posts

Posted - 2007-06-05 : 07:18:39

Hi,

Warm Wishes to u all !!!

I want to take backup of database thru T-SQL stmt.

My Code is

BACKUP DATABASE 'D_OpticalPortals',
TO DISK = 'C:\Test.dat'

Not Working

Plz do the needful

Regards & Thanks to All

Aravind

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-05 : 07:21:19

Remove extra comma after database name.

BACKUP DATABASE D_OpticalPortals -- , Remove this comma
TO DISK = 'C:\Test.dat'

Also, db name need not be enclosed within quotes.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

aravindt77
Posting Yak Master

120 Posts

Posted - 2007-06-05 : 07:39:49

Thanks a lot Harsh

I was too busy that I coulnt go longer with Books Online..

Thanks once again

Aravind

aravindt77
Posting Yak Master

120 Posts

Posted - 2007-06-05 : 08:39:17

Quick background

DynamicRegistration component saves User Responses only if user selects it -
otherwise there is no row created in a database. So for this reason we need
to create user's response for "not selected" options. The
Jobson.OpticalConnector.WebServiceProvider's Business Layer is responsible
for compiling a full list of "Subscription lists" and User's "response" as
true/false if there is match.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources