Viewing 15 posts - 36,376 through 36,390 (of 49,562 total)
guptaajay1985 (10/9/2009)
When I restore a full back up then I also got a log file at restore...
Yup, it's a full database backup. It restores the full database to the state...
October 9, 2009 at 9:12 am
Silverfox (10/9/2009)
Why would you automatically run REPAIR_ALLOW_DATA_LOSS, check what dbcc checkdb returns first. using any of the repair options is last resort until you see what the problem is.
If a...
October 9, 2009 at 9:12 am
2TB is the max permissible size for the tran log, so saying that the file is limited to 2TB is the same as saying unrestricted growth.
October 9, 2009 at 9:10 am
sudarram (10/9/2009)
One of my Critical Database went to Suspect mode due to unavailablility of a SAN Drive.The Drive is up now but not the database.Should i need...
October 9, 2009 at 9:08 am
Well, there are no incremental backups in SQL Server. Do you mean differential or are you referring to log backups?
October 9, 2009 at 9:07 am
hypermommy (10/9/2009)
October 9, 2009 at 9:03 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 9, 2009 at 9:00 am
Absolutely without question yes. As a consultant it's even more important than for a full time employee. When you're consulting, up to date, deep knowledge = work. If there's stuff...
October 9, 2009 at 9:00 am
That's saying when CheckDB last ran successfully. It's not saying that checkDB has just run, it's not saying that checkDB ran since the last time SQL was started. The date...
October 9, 2009 at 8:54 am
Krasavita (10/9/2009)
I am sorry to ask a a stuped question,but I want to know is id good that is contains 31 rows in a page?
It's not good or bad. It's...
October 9, 2009 at 8:47 am
I didn't ask about full backups. I asked about log backups.
Have you yet read the article that's been recommended several times?
October 9, 2009 at 12:18 am
rambilla4 (10/8/2009)
Change page verification to CheckSum (from Torn page)
why this step required?
A database upgraded from SQL 2000 will have page-verification set to Torn Page. SQL 2005 introduced the Checksum...
October 9, 2009 at 12:12 am
Add integrity checks for the system databases. Finding that master is corrupt and there's no clean backup (because it's been corrupt so long that the last good backup was deleted...
October 9, 2009 at 12:11 am
guptaajay1985 (10/8/2009)
I only want to shrink my log files without deleting.....
Why? The log should not be regularly shrunk. It should be set to the size it needs to be for...
October 8, 2009 at 11:58 pm
Something tells me this is not the documented behaviour. I call bug.
October 8, 2009 at 2:59 pm
Viewing 15 posts - 36,376 through 36,390 (of 49,562 total)