Best way to backup and restore sql server databases

Other SQL Server Topics
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)

1 Like
5

Check out the new Minion Backup