Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««89101112»»»

A Story of the Deleted Transaction Log Expand / Collapse
Author
Message
Posted Friday, August 7, 2009 1:36 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 6, 2014 12:59 PM
Points: 801, Visits: 1,962
GilaMonster (8/7/2009)

The fact that it's not in the GUI doesn't mean it's not an available feature. 2005 has the copy_only feature, but it's missing from the dialog and so can only be used with scripted backups


Rats! Thanks. I had seen a number of articles and posts showing the lovely check box. It would have been so nice to be able to put out a memo to the support staff "When grabbing a copy of a production database for testing purposes, alway check this box". Now I have to write up something for the team "Wen grabbing the database write this script."

Life would bee too easay if life was easy.


ATB

Charles Kincaid

Post #767250
Posted Friday, August 7, 2009 1:44 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 40,258, Visits: 36,681
Charles Kincaid (8/7/2009)

Rats! Thanks. I had seen a number of articles and posts showing the lovely check box. It would have been so nice to be able to put out a memo to the support staff "When grabbing a copy of a production database for testing purposes, alway check this box". Now I have to write up something for the team "Wen grabbing the database write this script."


Are you using differential backups? If not, there is no reason to use copy-only on full database backups.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #767259
Posted Friday, August 7, 2009 2:25 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
Lynn Pettis (8/7/2009)
talltop (8/7/2009)
Uh oh! thread hijack...GSquared, stay on point dude. We are talking about corporate production databases, not automobiles... apples and oranges....


Hate to tell you, but discussion threads here on SSC due tend to go off on tangents at times. Happens all the time and is part of being a SQL Server Communitity, not just a SQL Server Forum. In fact if you carefully read the tagents, you will find them quite enlightening. Plus, they usually come back to the main topic on their own.


Hmmm.... this is the first forum I have seen that allows thread hijacking. Most forum admins are all over that. For just one example, try that on the SQLMag forums and see what happens.. I have seen people get banned on that forum for consistently doing that...:)


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #767276
Posted Friday, August 7, 2009 2:51 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 40,258, Visits: 36,681
That's SQLMag, not SSC. Thread topics drift here, Steve doesn't intervene unless there are personal insults flying around, which doesn't happen often. Sometimes they drift back on topic, sometimes they don't

Besides, Gus didn't hijack the thread, he made an analogy. It wasn't as if he posted saying something like "Hey, I need help in fixing some problem completely unrelated to the current thread". That kinda thing is better in a new thread, if only cause more people will see it.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #767283
Posted Friday, August 7, 2009 2:54 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 6, 2014 12:59 PM
Points: 801, Visits: 1,962
GilaMonster (8/7/2009)
Charles Kincaid (8/7/2009)

Rats! Thanks. I had seen a number of articles and posts showing the lovely check box. It would have been so nice to be able to put out a memo to the support staff "When grabbing a copy of a production database for testing purposes, always check this box". Now I have to write up something for the team "Wen grabbing the database write this script."


Are you using differential backups? If not, there is no reason to use copy-only on full database backups.


Yep. Full.

I like full recovery mode as I've seen it save my butt numerous times like power outages (cuts) and such. I don't want to interfere with client backup procedures. If I take a full backup in full mode and the client is using some third party backup solution now they start getting log growth because their solution is not doing log backups.

The "copy only" thing lets me leave their stuff alone. I get all the benefits. Good recovery, minimal hassles with backups, small log growth.


ATB

Charles Kincaid

Post #767287
Posted Friday, August 7, 2009 3:09 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 1:20 PM
Points: 133, Visits: 472
Hey everyone, I am amazed that my article led to so many posts, even if many have nothing to do with it.

I was just checking on the latest posts and noticed a ranking i haven't seen before of "Mr or Mrs. 500". I never paid too much attention to the rankings but this one caught my eye. What does that one mean, and is there a list of all the different rankings. Oh yes do not call me a thread hijacker! :)




Jimmy

"I'm still learning the things i thought i knew!"
Post #767299
Posted Friday, August 7, 2009 3:21 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 40,258, Visits: 36,681
imSQrLy (8/7/2009)
I was just checking on the latest posts and noticed a ranking i haven't seen before of "Mr or Mrs. 500". I never paid too much attention to the rankings but this one caught my eye. What does that one mean, and is there a list of all the different rankings.


This what you looking for?
http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #767305
Posted Friday, August 7, 2009 4:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 20,744, Visits: 32,556
talltop (8/7/2009)
Lynn Pettis (8/7/2009)
talltop (8/7/2009)
Uh oh! thread hijack...GSquared, stay on point dude. We are talking about corporate production databases, not automobiles... apples and oranges....


Hate to tell you, but discussion threads here on SSC due tend to go off on tangents at times. Happens all the time and is part of being a SQL Server Communitity, not just a SQL Server Forum. In fact if you carefully read the tagents, you will find them quite enlightening. Plus, they usually come back to the main topic on their own.


Hmmm.... this is the first forum I have seen that allows thread hijacking. Most forum admins are all over that. For just one example, try that on the SQLMag forums and see what happens.. I have seen people get banned on that forum for consistently doing that...:)


That is the difference between a Community (SSC) and a Forum (SQLMag). It is one of the reasons I am an active participant on SSC and not on the other forums very often except perhaps as a lurker.

I have learned more here because of things going off topic at times then I have anywhere else. It is amazing what little tidbits of information on can pickup if you look.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #767313
Posted Friday, August 7, 2009 9:11 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 20,744, Visits: 32,556
talltop (8/7/2009)
Whooaaa! really? Well maybe it is just me but if I had someone on my DBA maintenance team/rotation that did not know what the different db recovery models were then I would start reevaluating my technical DBA interview skills real fast :) I don't care if a developer knows what they are but if you are on the team and can change the db recovery model on any database and don't know what they are, then that is a problem..But maybe that is just me. :)


The problem is that many of these people are accidental DBA's. They have found themselves doing the job because noone else would. So it is easy to see how it happens. The scary part is that many of these folks don't take initiative to learn more about SQL Server until there is a problem and then everything is an emergency.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #767364
Posted Saturday, August 8, 2009 2:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 11:41 PM
Points: 5, Visits: 40
I think I would have detach and attach single file

EXEC sp_detach_db @dbname = 'pubs'
EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

sp_attach_single_file_db attaches the database to the server, it builds a new log file and performs additional cleanup work to remove replication from the newly attached database.

good job !

Thanks
Jose

Post #767385
« Prev Topic | Next Topic »

Add to briefcase «««89101112»»»

Permissions Expand / Collapse