Home » Database server » MS Sql

how to backup transfer stored procedures mssql 2005

November 29th, 2011 | | 0 Comments »

In SQL Server Management Studio navigate to your database. Right click it and select “Tasks” -> “Generate Scripts” “Next” Select your database from the list “Next” Select “Stored Procedures” “Next” “Select All” “Next” “Script to new Query Window” “Next” “Finish” Give it a while. Then when complete, at the very top of the script put [...]

HOW-TO: Automatically Backup a MS SQL Server Database

November 28th, 2011 | | 0 Comments »

I am using Microsoft SQL Server 2008 Express but you should be able to use these instructions for all versions of Microsoft SQL Server 2005 and Microsoft SQL Server 2008. In my case, the database files are located in the following directory: CODE C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA As you may already know, you cannot backup [...]

1