Viewing 15 posts - 9,616 through 9,630 (of 22,213 total)
One method I've seen people use to get around this is to create a SQL Agent job that runs the RESTORE. Then, you give people permission to execute the job,...
August 30, 2013 at 5:12 am
Personally, this sounds like a job for PoweShell.
You can easily walk through the databases on a server, or from a list you provide, and then run your T-SQL script on...
August 30, 2013 at 5:09 am
It's not the best possible solution, but you can set up Alerts within SQL Agent. Here's the Books Online example of how to get it done.
August 30, 2013 at 4:58 am
Since it's happening overnight, there has to be a process that is getting run overnight. Do you have scheduled jobs. If so, what are they doing?
I wouldn't suggest rebooting the...
August 30, 2013 at 4:55 am
Hmmm... This is 2008 right? How about putting extended events to work. You could try a few events like database_created, database_file_size_change, database_started, database_data_file_size_changed, file_written. It's not an investigation I've launched...
August 29, 2013 at 6:29 am
Sean Pearce (8/29/2013)
http://www.apexsql.com/sql_tools_log.aspxApexSQL Log
Order now from $1,499 :w00t:
But that just reads the log. It doesn't read log backups.
Plus, you don't need a tool to read the log. There's an undocumented...
August 29, 2013 at 6:20 am
Youch.
First, I'd toss the query hints. Then, get rid of all the functions on columns in the JOIN criteria and WHERE clause. After that... who knows. I'm not even addressing...
August 29, 2013 at 4:40 am
No, that's pretty abnormal. I just did a test on one of my servers and I didn't see any difference at all in the time to create a database using...
August 29, 2013 at 4:34 am
Koen Verbeeck (8/28/2013)
JLMayes (8/28/2013)
TravisDBA (8/28/2013)
Agreed, but let's make sure ALL the facts are uncovered first before calling anyone out. Otherwise, it just turns the whole situation into a witch hunt.:-D
You...
August 28, 2013 at 3:49 pm
I have done something similar in the past, although it was all within a single domain. However, you should be able to adjust the basic scripts I've posted to my...
August 28, 2013 at 11:36 am
Just a suggestion, you should start a blog or write an article for SQL Server Central on something like this. You can get a lot more hits that way rather...
August 28, 2013 at 11:25 am
I'm not aware of a tool that lets you directly read a log backup file. I'm sure there's a way to do this (for example, Red Gate has a tool...
August 28, 2013 at 11:22 am
craig.schlieve (8/28/2013)
I am incredibly disappointed in you. This article is disgusting. You are advocating that groups form that will cause fractures in the community to do the...
August 28, 2013 at 7:31 am
I'm floored by this one too.
And while I absolutely agree with the sentiment that the idiot, uh, I mean, the alleged offender, should be publicly called out, the situation does...
August 28, 2013 at 6:35 am
Simplest suggestion I can make here is to let the relational system work like a relational system. Use the tools provided because they are a part of how SQL Server...
August 28, 2013 at 4:40 am
Viewing 15 posts - 9,616 through 9,630 (of 22,213 total)