This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We went at the old tried and true way, we detached the databases, moved the files, and re-attached the databases. That seemed to work well...
2009-02-20
2,133 reads
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...
2009-02-18
4,095 reads
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,159 reads
Brent Ozar wrote his Things you know now and in it he says this under his first point, Pick one...
2009-02-11
2,232 reads
Affected Versions:
SQL Server 2000 SP4SQL Server 2005 SP2Unaffected Versions:
SQL Server 2005 SP3 SQL Server 2008Original Vulnerability Report:http://www.securityfocus.com/archive/1/archive/1/499042/100/0/threaded
Microsoft Security Bulletin Link:http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx
Brief Analysis:
The...
2009-02-11
891 reads
This was the brainchild of Mike Walsh, who asked, "What do you wish you knew when you were starting?" I...
2009-02-10
1,277 reads
I should have put this out earlier, before going to the SQL Server Innovators Guild , but I got too busy. Here are my current speaking / teaching engagements for the first half of the year:
2009-02-10
158 reads
This is something that bit us over the weekend as we attempted to install two new SQL Server 2008 Enterprise...
2009-02-09
1,793 reads
Every time management / professional development book out there tells one to not only develop goals but actually write them down. That's...
2009-02-06
1,227 reads
I should have put this out earlier, before going to the SQL Server Innovators Guild, but I got too busy....
2009-02-06
690 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
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