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 12»»

Tempdb Expand / Collapse
Author
Message
Posted Saturday, January 18, 2014 1:27 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Comments posted to this topic are about the item Tempdb

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1532400
Posted Sunday, January 19, 2014 5:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:46 AM
Points: 13,646, Visits: 11,524
Easy one, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1532445
Posted Sunday, January 19, 2014 4:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 12:30 AM
Points: 1,804, Visits: 783
Nice n easy thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1532477
Posted Monday, January 20, 2014 12:19 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 12:08 AM
Points: 1,444, Visits: 690
Good one, thanx.
Post #1532510
Posted Monday, January 20, 2014 1:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 22, 2014 9:20 AM
Points: 2,624, Visits: 2,472
Very easy one!!! ... after reading BOL!
Post #1532518
Posted Monday, January 20, 2014 2:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:36 AM
Points: 2,233, Visits: 1,779
Well, like 50% of respondents I got it wrong (wasn't too sure on the .ndf option). Nice to learn that it was a really simple question though
Post #1532536
Posted Monday, January 20, 2014 2:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:32 AM
Points: 1,417, Visits: 809
Godd qotd to start the week.
Post #1532538
Posted Monday, January 20, 2014 3:26 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 3:15 PM
Points: 679, Visits: 987
Thanks for the question,

Since you cannot backup tempdb, it doesn't make much sense to be able to change the recovery model
Post #1532555
Posted Monday, January 20, 2014 4:55 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 4,164, Visits: 5,561
Forgot one cannot backup tempdb (not having done DBA work for quite a while)
Good question, thanks.
reminded me of some dba basics.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1532570
Posted Monday, January 20, 2014 6:36 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 1,930, Visits: 2,208
Knew the first two were wrong, but had to make a guess (wrong) about which of the remaining five was wrong. Thanks for the question.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1532607
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse