Viewing 15 posts - 1,291 through 1,305 (of 1,319 total)
I've started at a new company (We do NOT have Spotlight) but I'll bet the boys at my last employer would be interested in the fix. If they spring for...
-- You can't be late until you show up.
February 28, 2008 at 9:10 am
w.johnson is absolutely correct. I found this out when my log backups started failing and I received emails telling me that the database was not in "Full" mode. Took awhile...
-- You can't be late until you show up.
February 28, 2008 at 8:55 am
Some seemingly simple advice (although not useful for you right now): Do AT LEAST a weekly full backup up of your dev/test environments, more often if there are a lot...
-- You can't be late until you show up.
February 28, 2008 at 7:55 am
My fault. I need to pay more attention to the forum I'm in!:blush:
-- You can't be late until you show up.
February 28, 2008 at 6:55 am
I copy/pasted this directly into QA (SQL2000 sp3) and it will not compile. Errors as follows:
Server: Msg 170, Level 15, State 1, Procedure sp_who5, Line 38
Line 38: Incorrect syntax near...
-- You can't be late until you show up.
February 27, 2008 at 3:38 pm
Karl is absolutely correct. The compression size and speed of the backup (and restores) using third-party tools can be huge. We had a 250Gb database that compressed to around 32Gb...
-- You can't be late until you show up.
February 27, 2008 at 10:24 am
I am in a similar position, at a new company, and we are attempting to consolidate servers. I have identified that (from asking) 3 databases on a particular server are...
-- You can't be late until you show up.
February 27, 2008 at 10:14 am
I've used Lightspeed for years and recently SqlSafe (due to overall costs). Both worked well for compression and SQLSafe for encryption (didn't use that feature in Lightspeed). Backup and restore...
-- You can't be late until you show up.
February 26, 2008 at 1:00 pm
Gary, found this in another post. It describes the best ways to post questions/issues that you may be having. It's a good read and lays out what people need to...
-- You can't be late until you show up.
February 26, 2008 at 9:33 am
Didn't think about the hardware side of this but you may be right. It's a new virtual server and late yesterday I was told by infrastructure that they were having...
-- You can't be late until you show up.
February 26, 2008 at 7:08 am
Ran it when I got to work today, prior to doing anything to the indexes. Still no error. Also did a checktable, nothing. I did a DBCC DBREINDEX on the...
-- You can't be late until you show up.
February 25, 2008 at 3:46 pm
It's all bundled into one maintenance plan. The CheckDB for this particular database ran at 12:00:59am until 12:03:26am, reporting zero errors. The index build ran at 01:03:22am and failed at...
-- You can't be late until you show up.
February 25, 2008 at 2:33 pm
Actually, about a dozen databases on one server have the same logical name. I had never messed with the names before, always accepting the defaults on create. And I was...
-- You can't be late until you show up.
February 22, 2008 at 9:13 am
jbarkan - Just a suggestion - You've changed your topic focus. You may want to post your new request in a different forum, with an apporpriate topic heading as this...
-- You can't be late until you show up.
February 22, 2008 at 7:54 am
This may give you what your looking for:
exec sp_spaceused syscomments
and will yield:
name rows reserved ...
-- You can't be late until you show up.
February 22, 2008 at 7:38 am
Viewing 15 posts - 1,291 through 1,305 (of 1,319 total)