Stored Procedure for backup database in MS-SQL Server

In this stored procedure you have to send parameter to @path variable as your backup location.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


CREATE PROCEDURE [dbo].[sp_Database_Backup]
@path nvarchar(500)
AS
BEGIN


EXEC master.sys.xp_create_subdir @path
Set @path = @path + '\db_name.bak'
BACKUP DATABASE db_name
TO DISK = @path
  WITH FORMAT;
END

Steps for Add Google Maps API Into Website

1. Open http://maps.google.com/ Click on My Maps at Left side

2. Now Click on Get started

3. Now login window will appear. Here you can log in with your gmail ID/Password.

4. Now following screen will appear.

5. Now Search your location for google map script. Right click of mouse where you want to add a placemark and click on “Add a placemark”

6. Now Set the title of your placemark and give address of location in Description.

7. Now Click on Ok button then Click on Link button of right side of your browser screen.

8. Copy the iframe code and paste in your website.