Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • 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
  • Oracle: Database will not startup due to invalid parameter February 8, 2022
July 2022
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Jun    

Tag: restore log

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
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