It's only full backups.

Msg 8905, Level 16, State 1, Server 03RDP-EGAIN03, Line 1

Extent (1:500832) in database ID 6 is marked allocated in the GAM, but no SGAM o

r IAM has allocated it.

Msg 8905,...

the ob started failing from the 19th Agu 2010 and the Backup of the DB is still succeedingeven now but the integrity check of the same db is failing.

When i check on the eventvwr it seems a if there was an imprper shutdown or a force reboot of this server at 10:33PM on the 19-aug-2010 and i...

I have the backup of the last time this error was not there which is the 28 - Aug 2010.

What's wrong with my Databse? is it corrupt and cant it...

Msg 8905, Level 16, State 1, Line 1

Extent (1:204432) in database ID 6 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

Msg 8905, Level 16,...

Clearly the person who asked knows what he wants. please help.

I need the Syntax.

Lets say i want to set isolation for read commited snapshot ON. how do i go about?

Hi,

has anyone found a solution to this problem?

I also need help.

No, previus backups get deleted as the 1st step, before new backup step runs.

There is more than enough space on the drive regardless of old backups existing.

the backups are not overlapping, one finishes at 1AM and the other takes forver until it breaks whilst its on 50-60%

First of all are you a memeber of sysadmin on the server?

Do you have rights on the Databses ou are trying to add maintenance plans to.

i have data.mdf that i need to attach to ssms, when i try to attach this file i get access denied.

I need to attach this file so that i can...

Hi,

I am unable to tel the log size because the ldf files of this database are failing to be attached so that they can be available for browsing, actually i...

Quite Honestly i have no idea on the Database properties.

This is a user just requesting help. Let me find out more about the table properties.

Yes you can remove the schedule successfully!! At first i even thought removing of the schedule before the Job could have been the cause but i have tested this on...