Viewing 15 posts - 8,116 through 8,130 (of 9,725 total)
PhilPacha (2/22/2010)
Springfield, Illinois, U.S.A.
Hey, my dad used to work in that town!
Not very elaborate for a state capital, is it? @=)
March 29, 2010 at 5:32 am
The armpit of Florida, Jacksonville.
And, in the spirit of the misconceptions part of this thread:
When my family moved out to Nebraska though (many years ago), some of my fellow...
March 29, 2010 at 5:22 am
Glad I could help.
March 23, 2010 at 6:32 am
Joy Smith San (3/23/2010)
So that SQL server can use the same space in log and it doesn't have to...
March 23, 2010 at 5:10 am
So long as SQL Server does not need any more space for the transactions, it will re-use the current space in the log.
Think of it like this: The transaction log...
March 23, 2010 at 4:45 am
Joy Smith San (3/20/2010)
Granted the space will not be returned unless you shrink it
Returned to what ? That sapce will not be used further.?
Returned to the OS. Freed up for...
March 22, 2010 at 4:42 am
See my post on page 1 of this thread. Create a brand new job to run every X number of minutes (however often you want), then pull the data from...
March 19, 2010 at 10:21 am
Ask SSC??? What's the URL to the post? I'm not seeing it in the SQL Server 2005 -> Backups forum.
March 19, 2010 at 5:09 am
Paul,
It isn't a silly question. Developers should not have that ability on Production. In fact, there should be a tight throttle on the # of people who do have production...
March 19, 2010 at 5:07 am
It's funny. This subject came up last night at our local users group. I'd never heard of it before then. Now you guys are talking about it on this thread....
Bulk-logged...
March 18, 2010 at 11:27 am
Who is responsible for the actual server, the physical box? Who installs the OS, monitors patch updates, and might install an anti-virus program on the box?
This is the person you...
March 18, 2010 at 10:58 am
jorge.torralba (3/18/2010)
March 18, 2010 at 10:42 am
CirquedeSQLeil (3/18/2010)
Brandie Tarvin (3/18/2010)
... (keeping in mind you first have to restore the full db to SQL 2005 and it will be upgraded).
You only need to restore the Primary...
March 18, 2010 at 10:37 am
Be very careful about using compression & encryption on your database backups at the same time. These two tools don't play play well together and can hose your backup files.
To...
March 18, 2010 at 10:35 am
Viewing 15 posts - 8,116 through 8,130 (of 9,725 total)