Right-click on the msdb database in Object Explorer. Select Reports, Standard Reports and the report Disk Usage by Table.

See if you can identify the table taking up the space...

Guarav answered the question quite well - if you still need help with that, let us know.

No - you don't need a device. Just like the normal restore command you need to use the disk parameter.

Restore ... with disk = '...'

Try the restore filelistonly on the backup file. It will be something like 'AdventureWorksDW' for the data file and 'AdventureWorksDW_log' for the log file.

Yes - you need to specify the logical file name, not the physical name. You can get those using:

Select * from sys.database_files

Or

Restore filelistonly

The error is telling you that it cannot find the backup file you have specified. Validate the backup file actually exists where you think it does and the name...

rahul_dhar (5/31/2010)

---

It completely depends on your strategy.If resources are not a constraint a Weekly full and followed by daily differential is enough. Also you should possibly look at table partitioning...

Yes, the replace option exists because SQL Server still knows about the database. When the system was restarted, the database would show up as suspect in this scenario.

If you...

It's really not an issue using WITH INIT/NOINIT - it's the reuse of the same file name. It's fairly trivial to generate a file name based upon a date...

No, if you are going to remove (or disable, which I prefer) the BUILTIN\Administrators group you need to provide the user(s) running the services privileges in SQL Server.

In SQL Server...

It is possible if you use Powershell and SMO - where you have access to that default value. You can build a script to loop through each database and...

If you are using this for a drop-down, I would recommend having two columns. The first column will be the item value, the second column will be the item...

When Gail stated that you should back up to individual files, one of the things this does is makes sure you don't do this:

-- Back up the AdventureWorksDW transaction log

BACKUP...

How often are you backing up the transaction log?

Review the article I link to in my signature about maintaining transaction logs - it will help you understand what you need...

Paul is correct - I get lazy and don't specify the object type all the time.