Note: (almost) three year old post

Hi Ninja;

By now, I'm sure that you've looked it up in BOL, but it's worth mentioning for others who read this thread; a constraint if you're implementing this function is...

jstrauch 3024 (5/5/2011)

---

So Steve what would you recommend then for those poor souls? As being one of them it drives me nuts to constantly be told I can't get...

Hi,

I'm surprised to see that even Microsoft documentation uses the term "brain-dump".

I'm not clear on what that term means.

Is a "brain-dump" when someone writes the exam then tries to remember...

As a comparative outsider - not a DBA, I truly agree with the comments that have been posted here. The DBA role is a critical one and must be carefully...

Craig Purnell (4/12/2011)

---

Hi, Need to clarify this a little more. The technique described above is done by an addon product called Snapmanager for SQL Server. It is not cheap. That...

Wildcat (4/12/2011)

---

FYI - I believe the SAN company whose name starts with N does a restore on another LUN and then a checkdb on the database after it is backed...

Craig Purnell (4/8/2011)

---

You can also of course SAN replicate the drive storing your actual database backups.

We are doing this - we backup to a cifs share , then that...

Thanks Grant, George.

I couldn't have asked for better experts to weigh in on this.

I've been researching this and there are differing opinions, particularly in the case where the RPO dictates...

Gail has an excellent article on this.

http://www.sqlservercentral.com/articles/Corruption/65804/"> http://www.sqlservercentral.com/articles/Corruption/65804/

I know that you're asking specifically about the suspect state (she avoids getting into that discussion in this article); however,...

Grant Fritchey (12/8/2010)

---

That's a big topic. I'd suggest you take a look at this book (it's a free download) on Team Development[/url] from Red Gate. I wrote the chapters on...

webrunner (11/23/2010)

---

Thanks so much. I'll just restore to a slightly different...

Here are a few (of many) good reads on the topic:

By Paul Randal:

(he can't be more blunt than this)

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(930)-data-file-shrink-does-not-affect-performance.aspx"> http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(930)-data-file-shrink-does-not-affect-performance.aspx

and

http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx"> http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx

Another good one...

Hi Alan;

Someone with much more expertise than I will be by in a moment to provide correct syntax, but " getdate() - 30" does not subtract 30 days, it subtracts...

InfiniteError (11/30/2010)

---

hello again, i found out that it's better for me to create a 3rd party app to do all this things(modifying system table, view and modifying transaction log.) im...