Microsot didnt' give any easy option to backup a database with SQL Server Management Studio Express (SSMSE). But I've using Toad for SQL Server and that software provides with a SQL query to do so:
****************************************
BACKUP DATABASE [dbname] TO
DISK = N'C:\tempdirectory\dbname.bak' WITH
NOFORMAT,
NOINIT,
NAME = N'dbname-Full Database Backup',
SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10
GO
****************************************
Just update dbdname and tempdirectory in the query above to suit your case. And launch this query within SQL Server Management Studio Express, it will create a new file in your tempdirectory. You may restore the database thanks to that file later on (to do so right-click on the item databases in the tree in SSME, then restore).
;-)
No comments:
Post a Comment