back-up script

navedjobs · #1 (**permalink**) 01-15-12, 12:48

can any one give me a very simple back up script that buck up full database
to a given location
simple like

Code:

backup database databasename to "c:\users\desktop\name.bak"

navedjobs · #2 (**permalink**) 01-16-12, 13:01

Quote:

Originally Posted by navedjobs

can any one give me a very simple back up script that buck up full database
to a given location
simple like

Code:

backup database databasename to "c:\users\desktop\name.bak"

please help !!!!!

Pat Phelan · #3 (**permalink**) 01-16-12, 13:04

See BACKUP (Transact-SQL) for a full description of options, but you could start with:

Code:

BACKUP DATABASE putYourDatabaseNameHere
   TO DISK = 'c:\BackupPath\BackupFile.BAK'

-PatP