Jwalin Khatri

Posts Tagged ‘Database

Restore Database by SQL Scripting

Posted by: jwalin on: July 9, 2008

 
 
RESTORE

DATABASE [xxxxxxx] 
 

 
FROM DISK = N‘C:\backup\BackupDatabase.bak’ WITH FILE = 1,
 

 
MOVE N‘xxxxxxx_Data’ TO N‘C:\DATA\xxxxxxx_Data.MDF’,
 

 
MOVE N‘xxxxxxx_Log’ TO N‘C:\DATA\xxxxxxx_Log.LDF’,
 

 
NOUNLOAD, REPLACE, STATS =10GO

Tip/Trick: How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database
http://weblogs.asp.net/scottgu/archive/2007/01/11/tip-trick-how-to-upload-a-sql-file-to-a-hoster-and-execute-it-to-deploy-a-sql-database.aspx


Blog Stats

  • 15,017 hits

  • jwalin: Follow the following steps 1]. open you Page in NOTEPAD. 2]. find the tag 3]. Replace the "body" like body oncontextmenu=”return false;" 4]. Sav
  • cytocine: Halu , how to put that , i mean where to put the part ?? i really dont know i hope you can help me out thanks..
  • elmerdolor: Halu , how to put that , i mean where to put the part ?? i really dont know i hope you can help me out thanks..