what is the size of the db that you are backing up and what other things are there on F drive ?

Depending on the features you have choosed during installation but for sure sql server engine and sql server agent will be installed.

Other than that you have full text search,...

yes antivirus s/w will definitely lock down resources and will prevent it from working smoothly. You need to get with your vendor and find out solution as you can't live...

database is down meaning it went in suspect mode or what

to solve your problem immediately add another file to primary filegroup or any other filegroup for which 100% growth happened...

if you want the backup to happen only at 11:00 and than directly at 3:00 PM you need to create two schedules for mp rather than one.

Try this using ssms

go to mangement- mp

Right click on maintenance plan - new maintenance plan

Give name to mp

On left hand side, under mp tasks select backup task

in dialog box...

create dedicated logins to be used for linked server configuration. Use that logins to map sql user logins and it will work fine.

try restarting sql server services and login this time using sa account. This would solve your problem

You will not face any such problems yet. I migrated 6.5 tbs database yesterday from 2000 to 2005 and just needed to change compatibility mode to 90.

ensure that you physical...

you need to ensure that sql server services start on domain service account rather than local system

Ensure that you have taken production db backup before you migrate changes to production database.

Suspect state tells that database is corrupted meaning either physical files or filegroups are damaged or logical entries in system tables has been corrupted.

Checkpoint

Writes all dirty pages for the current...

Go to database- security - double click on logins that you want to disable or deny permissions

go to securable- click on add-object type - select table- check on deny permission...

Thanks for noting it. It is updatable subscription with immediate updating.

Hi,

Just for more troubleshooting can you create job with T-sql job steps to take backup and see whether that is working fnie.