Viewing 15 posts - 12,541 through 12,555 (of 22,219 total)
In general, except for data, most of the time the flow of structural changes is not from production down to a dev or test environment, but the other way, from...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2011 at 4:59 am
You could create a table with the list of distinct database names and then run a query against that to provide a list of files for the backup. That's the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2011 at 4:56 am
The information is available, but it's not collected in a month-to-month fashion. You have to make that collection yourself. I'm assuming you don't have monitoring set up. I'd start there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2011 at 4:47 am
Steve Jones - SSC Editor (5/17/2011)
Grant Fritchey (5/17/2011)
True, but this one time, I'm taking the supposed high road. I've posted that I have sessions. I'm done. Vote or not. I'm...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2011 at 10:09 am
Ninja's_RGR'us (5/17/2011)
Here's another option...
Excellent! I didn't want to bring it up, but this is a perfect solution, and one that uses very few disk resources to give you a perfect...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2011 at 7:30 am
Anjan Wahwar (5/17/2011)
Grant Fritchey (5/17/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2011 at 7:28 am
Jeff Moden (5/17/2011)
Grant Fritchey (5/16/2011)
Jack Corbett (5/16/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2011 at 7:27 am
buferis12 (5/17/2011)
ahh thats bad 🙁 SO reverse engineering wouldn't help too? Btw, yeah there is things called stored procedures in that db.
There you go. You can't possibly know what's going...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2011 at 5:24 am
Without a transaction, a rollback of a delete statement requires you to have already stored the data elsewhere. If you really need complete recovery and you're working within DTS, why...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2011 at 5:12 am
Not a problem. Nice to have met you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2011 at 5:03 pm
GilaMonster (5/16/2011)
Grant Fritchey (5/16/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2011 at 2:13 pm
I don't know, we'll have to renogiate the rate now...
Here's a little query to just get you started:
SELECT bf.logical_name,bs.backup_finish_date
FROM dbo.backupfile AS bf
...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2011 at 2:10 pm
Jack Corbett (5/16/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2011 at 1:47 pm
Yeah. That way you don't have to guess what the backup name is.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2011 at 1:44 pm
You could use SSIS and schedule it from SQL Agent. You could use a PowerShell script and run that from SQL Agent. You could probably use a linked server and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2011 at 1:15 pm
Viewing 15 posts - 12,541 through 12,555 (of 22,219 total)