Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Using dbatools to find orphaned files July 6, 2022
  • SSMS: Saving changes is not permitted error June 7, 2022
  • SQL Server: TableSample clause May 4, 2022
  • T-SQL: Create a running total April 6, 2022
  • Sql Server: Find the location your backups are going to. March 3, 2022
July 2022
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Jun    

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
  • Follow Following
    • Jim Salasek's SQL Server Blog
    • Join 27 other followers
    • Already have a WordPress.com account? Log in now.
    • Jim Salasek's SQL Server Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar