Viewing 15 posts - 29,416 through 29,430 (of 49,552 total)
Craig Farrell (11/11/2010)
:w00t: I thought I was picky. Guess it depends which online bible you reference. :hehe:
I referenced the real one on my books shelf, but it's plain-ish...
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
November 11, 2010 at 10:12 am
nealhudson77 (11/11/2010)
I realise it won't give me the User - but will it give me the time?
If you restore the logs, all that you will see in any auditing/tracing tool...
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
November 11, 2010 at 9:10 am
An trace file with 4 RESTORE LOG events in.
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
November 11, 2010 at 8:22 am
That should be fine. Check sys.dm_exec_requests, see what the wait type is.
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
November 11, 2010 at 7:59 am
jpertell (11/11/2010)
Would the transactions in question still be in the log after a transaction log backup?
Maybe.
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
November 11, 2010 at 7:32 am
If the actual log file is shrinking, it means you have auto_shrink enabled. Turn it Off! Autoshrink should never, never, never be enabled.
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
November 11, 2010 at 7:32 am
Huh? That's not even valid syntax.
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
November 11, 2010 at 7:24 am
nealhudson77 (11/11/2010)
Would 2008 offer more?
Yes, it has more options available. You would still have to set them up though.
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
November 11, 2010 at 7:23 am
nealhudson77 (11/11/2010)
That Apex tool only works on SQL 2000 🙁
No it doesn't.
http://www.apexsql.com/sql_tools_log.aspx
Support for SQL Server versions 2000, 2005, 2008, 2008 R2
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
November 11, 2010 at 7:22 am
It's not transaction logging that you want.
SQL logs all transactions, for database integrity and recoverability. Depending on the recovery model those stay in the transaction log for different amounts...
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
November 11, 2010 at 7:16 am
ps. (11/11/2010)
was the instance restarted? if yes it may take a while to roll forward transactions which depends on certain configuration settings.
That's recovering, not restoring.
The DB will go into 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
November 11, 2010 at 7:14 am
jcrawf02 (11/11/2010)
Craig Farrell (11/10/2010)
Must be the week...http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx
Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy spool and thy...
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
November 11, 2010 at 6:51 am
nealhudson77 (11/11/2010)
I wrongly assumed that turning on transactino logging would be enough.
What do you mean by 'turning on transaction logging'?
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
November 11, 2010 at 6:50 am
Henrico Bekker (11/11/2010)
create a small db in 2011, set compat mode to 2008, back up, try to restore in 2008, see the unexpected weird error.....
Not expected to work. Has never...
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
November 11, 2010 at 6:29 am
MostInterestingMan (11/11/2010)
I have a database stuck in 'restoring' but there is no restore progress in the sql logs. Should I just let it continue?
Was this DB restored from 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
November 11, 2010 at 6:16 am
Viewing 15 posts - 29,416 through 29,430 (of 49,552 total)