I run to backup db in SQL Server 2008 Express. Why when i do it Tasks-Backup and press "OK" it perfectly works. Yet when i do the same but click the Script button at the top of the dialog box and SSMS generates the SQL statement:
BACKUP DATABASE [AdventureWorks2008R2] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\AdventureWorks2008R2.bak' WITH NOFORMAT, NOINIT, NAME = N'AdventureWorks2008R2-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO
I run the query, yet the query seems cannot be completed. 10+ min. What's wrong?