C#

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- backup a database
ALTER PROCEDURE [dbo].[sp_BackupDatabase]

	@databasename varchar(32),
	@path varchar(256),
	@filename varchar(64)

AS

set nocount on

declare @sql varchar(4000)

select @sql = 		'BACKUP DATABASE ' + ltrim(rtrim( @databasename ))
select @sql = @sql + 	'   TO DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim(@filename)) + ''' '
select @sql = @sql + 	'   WITH INIT'
--print @sql
execute ( @sql )

select 'Database successfully backed up!' [Result]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go



ALTER PROCEDURE [dbo].[sp_RestoreDatabase] 

	@dbname char(32), 				-- the database name to restore as
	@filename char(64), @path char(256)		-- the location of the backuped up database file	(on the SQL Server)

AS

set nocount on

declare @sql nvarchar(3000)
 

-- Restore the database
select @sql = 			' RESTORE DATABASE ' + ltrim(rtrim( @dbname )) + ' FROM DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @filename )) + ''' ' 
select @sql = ltrim(rtrim(@sql)) + 	'    WITH '
select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + 'TNGoedit_Data' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '.mdf' + ''' , '	-- logical file name to physical name
select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + 'TNGoedit_Log' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '_log.ldf' + ''' '	-- logical file name to physical name
select @sql = ltrim(rtrim(@sql)) +  '    ,REPLACE,RECOVERY;'
--select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + ltrim(rtrim(@dbname)) + '_Data' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '.mdf' + ''' , '	-- logical file name to physical name
--select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + ltrim(rtrim(@dbname)) + '_Log' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '_log.ldf' + ''' '	-- logical file name to physical name
print @sql
execute ( @sql )

-- Was the command successful or was there a problem
if ( (select @@Error) = 0 ) begin
	-- Put an entry into oDirect.dbo.tbl_dbRef
	-- execute ( 'sp_DataSet_Save ''' + @xml + ''' ' ) 	

	-- TODO: restore the users

  select 'Restore Successful' [Result]
end
else begin
   select 'Restore Unsuccessful' [Result]
end

EliottA wrote:

Honestly, wikipedia isn't available in your native tongue?

d@nish wrote:

Don't you trust MSDN?

<br />
Constant :- once define; you can't change it,,

<br />
Abstract <br />
When you don't clear about the future expansion of the framework... <br />
For creating multiple version application..<br />
For creating products...<br />
For putting common behavior so that drived classes can use it without writing code again & again...

Interface<br />
For defining rules and business policies...<br />
To enforce something....<br />
to overcome the problem of multiple inhetitence

string sFile = string.format{"http//somedomain....{0}",ID);

for (int i = 3483; i < 3583; i++)
            {
                string sFile = string.Format("http://www.svenskaspel.se/includes/xmlelements/XMLresultat.asp?produktid=1&omgang={0}", +i);

                XmlDocument doc = new XmlDocument();
                doc.Load(sFile);
                doc.Save(Application.StartupPath + "/test.xml");
                //doc.Save(C:\\ + sFile);
            }