Viewing 15 posts - 42,091 through 42,105 (of 49,562 total)
Jeffrey Williams (12/30/2008)
The question I have is what else could cause a database to not have a current backup. Is this a bug that existed in an earlier version?
That's...
December 30, 2008 at 12:54 am
GilaMonster (12/29/2008)
How many rows do you need to delete, how many rows are you keeping?
December 30, 2008 at 12:47 am
I found the bug that I was thinking about, but it's 2005 RTM, fixed by SP2
http://support.microsoft.com/kb/921106
If the diff succeeds on the sat, but fails on the sunday, I think you're...
December 30, 2008 at 12:38 am
biniyb (12/30/2008)
It seems that you tested an error message pertaining to the log backup...i'm having an issue with the DIFF backup. Unless i completely misunderstood your explanation.
The test was for...
December 30, 2008 at 12:23 am
Bini, I seem to recall there's a bug in one version of SQL regarding the diff backups. Perhaps a google search of support.microsoft.com would turn something up
Jeffrey : I setup...
December 30, 2008 at 12:07 am
How many rows do you need to delete, how many rows are you keeping?
December 29, 2008 at 11:59 pm
See here for all certification info - http://www.microsoft.com/learning/mcp/certifications.mspx
To upgrade MCDBA to SQL 2008 MCITP (DB Admin), you need to first get the SQL 2005 MCITP (DB Admin), as there's not...
December 29, 2008 at 11:58 pm
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic627024-149-1.aspx
December 29, 2008 at 11:53 pm
Depends on what FTP program you're using. See it's manual/help file for how to check what mode the transfer is in.
I know the file is transfered, but that doesn't mean...
December 29, 2008 at 11:51 pm
Is the FTP succeeding? Is the file transferred completely?
Are you doing the FTP in binary mode?
December 29, 2008 at 11:09 pm
Jeffrey Williams (12/29/2008)
When you change the recovery model from SIMPLE to FULL or FULL to SIMPLE, the database is marked as *requiring* a full backup before you can perform a...
December 29, 2008 at 11:00 pm
Aspet Golestanian Namagerdi (12/29/2008)
Is it safe to work with system tables and fallowing TSQL:
If your goal is to corrupt your database and cause downtime and loss of data, sure.
It is...
December 29, 2008 at 1:51 pm
joshcsmith13 (12/29/2008)
December 29, 2008 at 1:47 pm
biniyb (12/29/2008)
But as far as File-System backups go, my SA here uses Legato which is different from NTBackup.
Can you check and ensure that Legato's not also doing SQL backups of...
December 29, 2008 at 12:26 pm
It looks like there's not enough space in the data file. To rebuild a clustered index, SQL needs at least as much space as the clustered index currently takes up....
December 29, 2008 at 12:22 pm
Viewing 15 posts - 42,091 through 42,105 (of 49,562 total)