Viewing 15 posts - 27,001 through 27,015 (of 49,552 total)
sue.bandi (3/29/2011)
Can any one tell me how to read log file (like what transaction happened etc) in SQL SERVER.
Why? What are you trying to do here? What are you...
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
March 29, 2011 at 3:53 am
At least one of the disk resources needs to be a dependency of the SQL service.
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
March 29, 2011 at 3:33 am
Write the query that returns the mismatched rows, once you're happy it returns the correct data, add the INTO clause.
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
March 29, 2011 at 3:25 am
Explain?
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
March 29, 2011 at 12:36 am
deepikamm (3/29/2011)
whether "create table table_name as select * from old_table" works in sqlserver?
No. The SQL syntax is SELECT ... INTO. Why do you not want to use that?
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
March 29, 2011 at 12:08 am
Craig, check the version in the error, it's a 2005 server.
Backup damaged, get a new backup
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
March 29, 2011 at 12:06 am
You might want to read up on log backups, so that you understand what they are.
Not deltas exactly, lists of operations that have occurred in the DB.
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
March 29, 2011 at 12:03 am
Take the database offline, open the mdf file in a hex editor. Search for a string you know to be in that table, overwrite with 0000000000. Save. Close hex editor,...
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
March 28, 2011 at 11:52 pm
invaliddba (3/28/2011)
An instance and a sql server are not the same though.
They aren't? Please list what you think the differences are.
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
March 28, 2011 at 11:34 pm
There were a couple promising-looking hits in this, I didn't take time to check them though
http://www.google.com/search?q=sql+2000+rebuild+index+script
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
March 28, 2011 at 1:10 pm
Got another backup? That one looks toast.
I assume that continue_after_error didn't help?
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
March 28, 2011 at 1:08 pm
Probably not if it didn't finish restoring. Try continue_after_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
March 28, 2011 at 12:34 pm
erdoganaktas (3/28/2011)
Really I expected to analyze this result. French or EnglishWhat the change ? 😉
You do realise that we are all unpaid volunteers here?
I want to rebuild indexes over 30...
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
March 28, 2011 at 12:31 pm
Answer my questions. All of them.
I cannot see your screen, I cannot read your mind. I cannot help you if I don't know what you've done or what exactly 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
March 28, 2011 at 12:13 pm
No, because you are giving me no where near enough information.
Did the script run successfully?
Did you restart SQL afterwards?
Is MSDB online?
Can you query it?
If not exactly what errors does 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
March 28, 2011 at 11:43 am
Viewing 15 posts - 27,001 through 27,015 (of 49,552 total)