Using SQL Server Management Studio
Open Microsoft SQL Server Management Studio (May need to be installed separately)
Connect to the "ServerName\Instance" of the server that has the DB you want to be backed up.
Expand the Databases tab to get to the DB you want to back up.
Right click the desired DB --> Tasks --> Back Up...
Set "Backup Type" to "Full"
Go through the rest of the General and Options tab information to set the options to what you want.
Click OK to start the Backup process.
Open Microsoft SQL Server Management Studio (May need to be installed separately)
Connect to the "ServerName\Instance" of the server that has the DB you want to be backed up.
Expand the Databases tab to get to the DB you want to back up.
Right click the desired DB --> Tasks --> Back Up...
Set "Backup Type" to "Full"
Go through the rest of the General and Options tab information to set the options to what you want.
Click OK to start the Backup process.
No comments:
Post a Comment