Gail Shaw

Forum Replies Created

Viewing 15 posts - 36,451 through 36,465 (of 49,552 total)

RE: Log shipping & DBCC SHRINKFILE ('Database', 13) is it safe

It's safe in that it won't break the log shipping. You will need to schedule an index rebuild afterwards, as shrink can severely fragment indexes.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 9:43 am

#1061837
RE: Best Autogrowth/AutoShrink Practise for TempDB

SQLCAT (Customer Advisory Team) did some tests a while back and found little improvement after 8 files. Hence the updated recommendation.
The other point is that SQL 2005 is much less...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 9:40 am

#1061834
RE: Recover from transaction log

homebrew01 (10/5/2009)
Would a log reader tool be usefule for extracting transaction information if a full backup was taken, and log backups have been taken, but the full backup no longer...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 9:38 am

#1061832
RE: Recover from transaction log

If there has never been a backup of the database, then no. Regardless of recovery model, if there has never been a backup of the database then the log will...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 7:46 am

#1061718
RE: Any benefit to shrink after Trans Log Backup (FULL recovery model)

repent_kog_is_near (10/5/2009)
Now, I have removed the second part - SHRINKFILE. This has probably done 2 bad things
*made Recovery to point-in-time not possible because of TruncateOnly
No, no, no!!!
There is a...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 6:58 am

#1061685
RE: 2 instances using the same database file ????

tvantonder-992012 (10/5/2009)
The two instance names are
server\MSSQLSERVER - Default
server\prsvr
Not the server name itselfs. Is this possible with Network??
Yes, absolutely.
I've seen a case where one instance could be connected to with either...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 5:37 am

#1061647
RE: Recover The data After Deleting

If you don't have any backup at all, then the chances of getting anything back are exceedingly slim. Regardless of recovery model, if there has never been a backup then...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 5:24 am

#1061643
RE: 2 instances using the same database file ????

It can be done (attach the DB while the other instance is stopped) but there's no way that the DB can be in use in both instances, SQL takes exclusive...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 1:17 am

#1061573
RE: .mdf file @ 0 bytes .ldf 6GB?

Probably not.
If you have no backups at all then, regardless of recovery model, the log would have been in auto-truncate mode, meaning log records got discarded after the checkpoint runs.
There's...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 1:12 am

#1061571
RE: Any benefit to shrink after Trans Log Backup (FULL recovery model)

Matt Miller (#4) (10/4/2009)
repent_kog_is_near (10/4/2009)
Yes Sir.
(btw - the correct salutation in this case would be "Ma'am". don't let Quaigon Jin fool you)
Not that "yes <anything>" is a useful answer 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 5, 2009 at 12:56 am

#1061567
RE: How I can make look like I expert on SQL Server?

Elliott W (10/4/2009)
The only right answer is a valid answer, "I don't know" or a crap answer will almost certainly be a disqualification for anything other than a junior or...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 4, 2009 at 12:03 pm

#1061483
RE: Any benefit to shrink after Trans Log Backup (FULL recovery model)

Than what do you mean by 'truncation of log ... after backing up the 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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 4, 2009 at 6:02 am

#1061438
RE: is Database available during backup?

Mark_Pratt (10/4/2009)
I say generally as a 2000 system I use to administer use to have problems with logshipping when the backup was running; but only on Saturday mornings ... Strange...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 4, 2009 at 5:48 am

#1061435
RE: How I can make look like I expert on SQL Server?

ItalianOlgi (10/3/2009)
Yes, I looking for a list of interview questions!
No amount of memorising questions is going to get you past a good interviewer. You need to understand the material, not...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 4, 2009 at 5:44 am

#1061432
RE: Any benefit to shrink after Trans Log Backup (FULL recovery model)

repent_kog_is_near (10/3/2009)
Back to the main question, and in relation to fragmentation, we have a process where for a while we have had a truncation of log right after backup. What...
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

October 4, 2009 at 5:35 am

#1061430

Viewing 15 posts - 36,451 through 36,465 (of 49,552 total)