Viewing 15 posts - 16 through 30 (of 468 total)
October 10, 2017 at 10:04 am
I figured this out today. The problem occurs when a linked server is created that specifies a local login before that local login is created. For example, if I create...
October 10, 2017 at 9:16 am
October 9, 2017 at 8:42 pm
dan.brown1 - Monday, October 9, 2017 3:26 PMyes, it gives same error forsp_detach_db 'sample'
GO
or
Use master;
ALTER database sample set offline with ROLLBACK IMMEDIATE;
DROP database sample;
Can...
October 9, 2017 at 4:57 pm
I'm unable to replicate that problem. The syntax you are using is just "drop database [name]" correct?
October 9, 2017 at 3:21 pm
Create a dummy file in another location. Then alter database modify file to change the specification of where the database exists. Restart SQL Server. It will come up suspect. Drop...
October 9, 2017 at 2:40 pm
July 7, 2017 at 5:57 am
July 6, 2017 at 12:22 pm
I wrote this article on the subject a few years ago: http://www.sqlservercentral.com/articles/Automation/76791/
July 6, 2017 at 12:05 pm
Iwas Bornready (12/9/2015)
Thanks for the good article and code.
Appreciate the feedback!
December 9, 2015 at 7:00 am
As written, the proc does not account for databases with multiple data files. It would be a pretty straightforward change to make though.
December 8, 2015 at 11:39 am
Yep, the code does a select of the sql statement before executing it.
December 8, 2015 at 10:42 am
denist80 (12/8/2015)
Thank you for the article!
How would this play if a VLDB is a primary replica in AG? Say, someone had a bad release and now needs to revert to...
December 8, 2015 at 7:32 am
Yes, you're right about the flowchart.
December 8, 2015 at 5:14 am
yes, right- I typo'd the first date. if it were 1/5 as in my original post, the result would be 3.
November 30, 2015 at 2:14 pm
Viewing 15 posts - 16 through 30 (of 468 total)