Viewing 15 posts - 21,526 through 21,540 (of 49,552 total)
satheessh (12/28/2011)
after tat we should take tail log back up of particular database by putting db in single user mode which is in restoring state
No. Tail log backup has to...
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
December 28, 2011 at 7:07 am
That won't create a suspect DB, all that will do is make the DB go through crash recovery after startup. It'll come online fine after that. SQL can handle crashes...
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
December 28, 2011 at 4:10 am
SQL will start with a row lock, as the hint requests, if necessary it will escalate that to a table lock.
Why the hints in the first place?
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
December 28, 2011 at 1:58 am
Bhuvnesh (12/28/2011)
If your mdf file is full then shrinking is out of the question and is not even applicable for discussion since you can't shrink a full file.
can u suggest...
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
December 28, 2011 at 1:23 am
Before you go to all the effort of splitting the files, check that you really are bottlenecked on IO (not memory or CPU) and that the queries as optimised as...
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
December 28, 2011 at 1:22 am
For a little more detail on what happens under the covers, you may want to read these:
http://www.sqlservercentral.com/articles/Administration/75461/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
December 28, 2011 at 1:12 am
Vertigo44 (12/27/2011)
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
December 27, 2011 at 2:04 pm
PaulB-TheOneAndOnly (12/27/2011)
Check the post dated 5/16/2009 12:02;17am on this thread: http://www.sqlservercentral.com/Forums/Topic717382-266-2.aspx
No. Please no. As Paul said (in that thread)
that is NOT the supported/documented approach and is only suggested when EMERGENCY...
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
December 27, 2011 at 2:04 pm
I hate to be the bearer of bad news, but you can't mix and match ldf and mdf files from different times.
To get that DB up, you'd need mdf...
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
December 27, 2011 at 1:56 pm
Vertigo44 (12/27/2011)
I believe this is a new installation and is only a few months old. (Oct or Nov of this year)
There are databases on there that date to July last...
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
December 27, 2011 at 1:27 pm
Vertigo44 (12/27/2011)
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
December 27, 2011 at 1:25 pm
There is no impact to any form of replication by changing the recovery models of the database to any of the options. The two features are independent.
http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/
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
December 27, 2011 at 1:21 pm
Do NOT detach, you won't be able to reattach it.
Best bet - restore from backup (and I don't mean a file backup of the ldf). Restore full, any differentials and...
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
December 27, 2011 at 1:08 pm
opc.three (12/27/2011)
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
December 27, 2011 at 12:57 pm
You can detach, rename and attach or you can use ALTER DATABASE with modify file, then take the DB offline and make the change to the actual file name.
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
December 27, 2011 at 10:47 am
Viewing 15 posts - 21,526 through 21,540 (of 49,552 total)