How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as...
2014-07-14
16,121 reads
Blog Posts
How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail....
2014-07-14
6 reads
Last Weeks Top “Reading” Links #92
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-07-14
377 reads
Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2
Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result no enchantment or no future release of SPs. Somehow,...
2014-07-14
3 reads
Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2
Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result...
2014-07-14
613 reads
Merge csv files – quick PowerShell snippet
During a bit of work I’ve been doing this evening for SQLRelay, I used something I have in my arsenal of...
2014-07-14
1,079 reads
Murder In Denver
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-07-14
4 reads
Murder In Denver
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-07-14
777 reads
My upcoming speaking schedule
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-07-14
1,011 reads
Some Ideas for Meeting Sponsors
Most PASS Chapter meetings are supported by sponsors who either provide money which is often used for food and drink,...
2014-07-14
735 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers