Backup - Restore SQL 2005

Acerca de Linux, BSD y notas personales

21 Sep

Posted in SQL Server by carlosap

T-SQL code

BACKUP:

USE myDatabaseName

BACKUP DATABASE myDatabaseName
TO DISK = ‘C:\filePath\myDatabaseName.bak’
NAME = ‘The name of the back up.’

RESTORE:

RESTORE databaseName

FROM DISK = ‘C:\filePath\backupFilename’

Database Price (Sep 22, 2007)
CBT SQL 2005 (Sep 22, 2007)
How to search all columns of all tables in a database for a keyword? (Sep 22, 2007)
SQL Server Port Firewall 1433 (Sep 22, 2007)
SQL Server y Visual Studio 2005 (Sep 22, 2007)

You must be logged in to post a comment.

About Me

ZiVo Nix Blog