SQLTeam.com | Weblogs | Forums

Best way to backup and restore sql server databases


#1

Could someone show me the fastest way to backup and restore sql server databases
Bob Ghodsi


#2

backup database dbName to disk = 's:\backups\dbName.bak' with init

restore database dbName from disk = s:\backups\dbName.bak'

Do you have a more specific question?


#3

Use SQL Server Management Studio. See screen shot below


#4

@TaraKizer my method is better :stuck_out_tongue_winking_eye: .

(Just kidding, I wanted to see if I can post a screen shot easily unlike the old forum software where you had to use a third party hosting site)


#5

Check out the new Minion Backup