Viewing 15 posts - 9,391 through 9,405 (of 49,552 total)
Don't use the GUI
Do your restores with T-SQL statements. Restore the normal log backups, in sequence, with norecovery, then restore the tail log backup. Extension is irrelevant, SQL doesn't care...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2014 at 3:34 am
That is a .net error. SQL Server is not written in .net, hence it's not a SQL Server error.
It's an application error.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2014 at 3:32 am
Yes, you can use T-SQL to restore multiple log backups.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2014 at 2:41 am
Use T-SQL.
RESTORE LOG ....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2014 at 2:18 am
praneethydba (4/8/2014)
Client is sitting next to me and asking for reasons...
Tell him that SQL is designed to use all the memory it is allocated and that using 90% of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2014 at 2:18 am
There's another session from somewhere else which is causing this. Identify where that other session is coming from.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2014 at 1:01 am
smallmoney (4/7/2014)
I'm new to this and just curious why can't it cut in line in the runnable queue.
Because it's no more eligible to run than any other process. If it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2014 at 12:57 am
You can't kill system processes, and from the value of the spid, that's likely a system process.
Why do you want to kill it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 9:02 am
Highly unlikely.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 8:59 am
Lynn Pettis (4/7/2014)
yuvipoy (4/7/2014)
inorder to hide my business process i have renamed the column.
while pasting here i did not mention as b.column names for the columns.
For execution plan since it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 8:30 am
Are you aware of the side effects of nolock?
Are your users happy to be getting reports and results which are intermittently incorrect?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 8:06 am
You are aware of the side effects of nolock? Your users are happy with intermittent errors in their reports?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 7:36 am
mark 95074 (4/5/2014)
System.Data.SqlClient.SqlError: The log in this backup set terminates at LSN 2804703000000039200001, which is too early to apply to the database. A more recent log backup that includes LSN...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 7:34 am
yuvipoy, you know full well by this point what we need to answer performance questions.
Table definitions, index definitions and execution plan please. Otherwise there is absolutely nothing anyone can say....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 12:57 am
matt6749 (4/6/2014)
If I have 12 different newsletters then each time a Customer record is created I've got to create 12 new records in the ancillary table.
Correct
Then my ancillary table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2014 at 12:55 am
Viewing 15 posts - 9,391 through 9,405 (of 49,552 total)