Are you backing up the transaction logs?

Are you shrinking the transaction logs?

Review the article in my signature on managing transaction logs. This should give you an idea of why...

First, importing maintenance plans directly from one system to the other will not work. The plan will be created, but the local connection will be set to the other...

This is a really stupid issue in the way they check the privileges. The issue is caused by how the username is setup in AD and how the login...

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...