subs99 (1/22/2010)

---

And then Microsoft warns over and over that you really don't have any backups unless you TEST YOUR BACKUPS! Wow, now that's a project! Does everyone actually test their...

Your best bet is to search internet to get an idea of DR and its importance. But, the actual DR will be specific to your companies needs.

dtutil:

You can use the dtutil command prompt utility to manage existing packages at the command prompt. You can access packages that are stored in the SQL Server msdb database, the...

run the script below to find any open transactions that could be the culprit...

dbcc opentran('tempdb')

I guess if it were a permissions issue then this job would never run. It could either be a network issue or a process accessing your disk at the same...

yay..:cool:

It looks to be an issue with cross database chaining..to fix it you will need to run the script below on both databases:

ALTER DATABASE db SET DB_CHAINING ON

Then just rename or delete the VS folder from the below path...

'C:\Documents and Settings\%username%\Application Data\Microsoft\VisualStudio'

Hope this helps...

Did you have SSAS or SSRS installed too?

I concur with Gail on not restarting the server to avoid having a Corrupt database in Suspect mode unless I am sure that it is only a hardware issue and...

You need to locate the registry key for the old installation and remove it before proceeding with the new install...

Are the databases on the two different servers owned by the same login?

You can easily script the BACKUP or RESTORE statement from a Backup Database/Restore Database dialog. Analysis Services 2005 even allows you to encrypt and compress backup files. Both backup and...

Can you run the query below and see the sizes then...

DBCC updateusage(myDB)

mohammed moinudheen (1/19/2010)

---

There was once when I had to restore a database.

Due to some reason, connections continued to persist on this database because of which I couldn't restore.

To overcome this,...