henryvuong1000 (3/19/2011)
Note that I did not use any tsql command why performing the above operations. I only used GUI.
What do you mean you used the GUI? There's no mechanism through the SSMS GUI to run CheckDB.
You said you 'ran the command'. If by that you mean a query window, paste that, press F5 (or use the menu), then the previous comments stand, there's an incorrect ` in that command.
Why didn't I create a regular tsql backup? Because it is simpler to copy and paste the files than running a tsql command. The person who works with me does not know anything about sql. That's the way she backs up sql database.
Simpler, wrong and quite likely to give you useless 'backups' that cannot be 'restored'. A file copy is not a SQL backup. That the person you work with does it, does not make it a good way or even a workable way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability