Skip to main content
How to restore database using sql command?

RESTORE DATABASE Test1 FROM  DISK = N'C:\inetpub\PoologicDatabaseBakFile\PoologicDataBase.bak'
  WITH REPLACE,
  MOVE 'PoologicsBakFile' TO 'C:\inetpub\PoologicDatabaseBakFile\Test1.mdf',
  MOVE 'PoologicsBakFile_log' TO 'C:\inetpub\PoologicDatabaseBakFile\Test1.ldf';

Comments

Post a Comment

Popular posts from this blog

How to convert string time to 24 Hours format in SQL. Declare @Test datetime Select  @Test=CONVERT(datetime, '06:59PM' , 120) Select Cast(@Test as time(0))
Post a Comment
Read more
How to download partial view content using c#? private static string CallApplicationControllerForSnapshotHtml(Guid subscriberId, int duration, long? subscriberUserId, string conString)         {             string myUrl = string.Format(ServiceConfigurationHelper.GetAppSettingValue("GetHtmlContentUrl") + "?subscriberId={0}&duration={1}&SubscriberUserId={2}&conString={3}", subscriberId, duration, subscriberUserId, conString);             WebClient wc = new WebClient();             string requestResult = wc.DownloadString(myUrl);             return requestResult;         }
Post a Comment
Read more