SQL Server Articles

SQL Server

• Backup your database using an SQL command (Export to .bak)
  Let rtpHarry guide you through backing up your sql server databases in the second of his tutorials on using Sql Server Management Studio to your advantage. Here we walk through the sql commands you need to execute to backup your database to file.
  Matthew Harris · 9/12/2009 · 5 · 7522 · share
• Backup your database using Microsoft SQL Server Management Studio Express (Export to .bak)
  A guide to show you how to make an individual backup of a database using SQL Server Management Studio Express.
  Matthew Harris · 8/21/2009 · 3 · 9349 · share
• Difference between @@Identity And Scope_Identity()
  In this article I have explained the difference between @@Identity And Scope_Identity().
  Raghav Khunger · 7/13/2009 · 1 · 2915 · share
• How to Restore a MSSQL 2005 Database
  Restoring a MSSQL 2005 database can mean problems for those that do not know how to do it properly. Especially if you are restoring this database on a different server than what it was created on. Read how to do it here.
  Tim Eisenhauer · 1/6/2009 · 0 · 7131 · share