Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Modify SSRS Subscription Retries April 7, 2021
  • Unable to enlist in the transaction using a Linked Server. Msg 7391, Level 16, State 2 March 2, 2021
  • Msg 4701, Level 16 trying to truncate table through Linked Server February 2, 2021
  • Msg 7399, Level 16, State 1 Linked Server. Access Denied January 5, 2021
  • Another feature I wish SQL Server had. December 3, 2020
April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Mar    

Tag: restore database

Restore Database using T-SQL

You can also restore your SQL Server database using T-SQL instead of SSMS.  Today I will show you how to do an easy recovery with restoring just a full backup and another scenario of restoring a full backup and any available transaction logs.

Continue reading Restore Database using T-SQL

Posted on March 21, 2017February 26, 2017Categories Hints and TipsTags norecover, recovery, restore database, restore log, t-sqlLeave a comment on Restore Database using T-SQL

Restoring your Sql Server Database

In a previous posting, we backed up your WideWorldImporters database and created a job to run transaction log backups so we can recover with no more than 30 minutes of data loss. Continue reading Restoring your Sql Server Database

Posted on January 18, 2017January 21, 2017Categories UncategorizedTags restore, restore database, sql server, ssms1 Comment on Restoring your Sql Server Database
Create a website or blog at WordPress.com