Viewing 15 posts - 19,651 through 19,665 (of 22,226 total)
I am such a dope sometimes.
http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/%5B/url%5D
"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
September 3, 2008 at 12:28 pm
It sounds like your maintenance plan is set up right. The scenario you described is not because of a database or log first or second, but because you have to...
"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
September 3, 2008 at 12:22 pm
Maybe I'm confused (hardly a new case), but however many log files you've backed up, you'll have to traverse them unitl you get to the log where the end time...
"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
September 3, 2008 at 12:11 pm
You can't really do logs first. You have to restore the database and then a series of logs and the backup has to be in the same order.
"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
September 3, 2008 at 11:55 am
Those files are not compatible with Management Studio.
As to where... it really depends on your shop and the processes there. For example, we use Visual Studio Team System Database Edition...
"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
September 3, 2008 at 11:53 am
Didn't I answer this one already today for you?
http://www.sqlservercentral.com/Forums/FindPost562957.aspx
"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
September 3, 2008 at 10:33 am
But the issue is the error message:
"nvarchar value "2147486776" overflowed an int column"
If you're selecting into a bigint variable from a big int column, where is the nvarchar and 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
September 3, 2008 at 9:14 am
Have you tried running the query against the base table?
Something is introducing a string in 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
September 3, 2008 at 9:08 am
And RecId is, for sure, a bigint?
"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
September 3, 2008 at 8:39 am
Well, to get it to execute 10 times, just use this syntax:
EXEC myproc;
GO 10
As to how to gather the average of 10 executions... It depends on how you're capturing 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
September 3, 2008 at 8:37 am
Look up.
Sql Server Central...
"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
September 3, 2008 at 8:14 am
It's possible your external IP address has changed? You shouldn't be sending people your internal IP address because it won't help them.
BTW, this is a SQL Server 2008 Forum. 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
September 3, 2008 at 8:12 am
Excellent! Looking forward to it.
"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
September 3, 2008 at 7:00 am
It only goes back as far as the last time the server was restarted, but you can track schema changes through the built in report "Schema Changes History." I ran...
"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
September 3, 2008 at 6:57 am
I'll pile on and suggest you have a Staging server that mirrors your Production environment (not necessarily in terms of memory & processing power, but certainly disk space) where 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
September 3, 2008 at 6:49 am
Viewing 15 posts - 19,651 through 19,665 (of 22,226 total)