Check your ERRORLOG for details to see if you find anything in there.  Sounds to me like like its waiting for another DB backup to complete for the same database.  Check...

This should help you:

http://www.databasejournal.com/features/mssql/article.php/2228611

Transfering logins correctly will transfer roles as well.

You sure you posted this enough time

Have a good one

I think in todays Volatile world of IT, it would be hard to imagine that a DBA is purely fullfilling only DBA roles.  Today a DBA needs to wear more hats...

Hi Guys,

Steve, I could switch traffic to the standby DB and rebuild this server - but for now I think I will just go with expanding the partition. 

Rahul, I had...

You should put SQL Server on its own server and then create a backplane between SQL Server and your webserver, so that only internal traffic follows between the SQL Server...

Update stats on both

Martin is right.  Try scheduling something like this to run on a regular basis that will clear backup history older then X days, change 60 days to one of your...

Put db in single user mode and then try the dettach. 

If you just want to see what recovery model the DB is running in you can simply issue the following command -

exec sp_helpdb db_name

besides other DB information - it will list...

1. You could change the job step type to Operating System Command (CmdExec) and use Osql.exe utility to send the results to an output file.

2.  Check SQL server error log...

REINDEX is far more efficient in my opinion, especially where fragmentation on clustered indexes is concerned.  But ofcourse it has a lot of overheads.  So normally what I practice is...

As Steve mentions - Backup and Recovery are key to any Database.  Before you decide what revovery model your database should run it - you need to get a a...

The whole point of the diff backup is that after you restore the full backup, you do not have to apply each trans log still the point in time -...

I believe with the new faster disks, you are not going to see a huge diff with defraging at the OS level, unless your DB is contantly growing and shrinking. ...