simple answer - do not shrink the log.

Backup your transaction log more frequently to avoid it filling, so instead of one transaction log backup job at 12pm , run it...

is 91% of the log file size greater than 760GB?

backup history can take a VERY long time to clean up if there is a lot of history to work through, the supplied code is not very efficient and IIRC...

look in the SQL errorlog for more specific messages, sounds like a database file is missing.

Not enough to worry about! the alter database command was designed for just such tasks and is the safest way.

anything in the reporting services logs?

Alter database is the preferred method of doing this. Its safer as the database is never actually removed form the instance so any risk when reattaching is mitigated. Also when...

no spaces

no reserved words

talinkio (12/4/2012)

---

Is it possible to have a SQL Server instance, say SQLProd01, span multiple windows servers? Let's go with 3 servers each having 2 DBs but all linking back to...

we actually schedule our check via SCOM, so if you have an enterprise monitoring tool like SCOM you would hopefully be able to plug the script into it.

-- GET DATABASES WITHOUT FULL OR TLOG BACKUPS

-- dbs with no full backups in last week

(select cast(a.[name] as varchar(100)) as db_nm into #no_full_backup

from master.dbo.sysdatabases a

left join msdb.dbo.backupset b

on a.[name] =...

A google search of 'script user permissions sql server 2000' returns a number but attached is one we used to use.

edit - if you found the script useful, please vote...

from http://msdn.microsoft.com/en-us/library/aa259221(v=sql.80).aspx

At any time, only one table in a session can have the IDENTITY_INSERT property set to ON. If a table already has this property set to ON, and a...

just to rule out the obvious are you using a 3 part naming convention in the insert statement?

looks like some sort of problem with the copy\paste from the site.

click on the error message in the results pane and it will take you to the actual error in...