Perry,

Sorry.

We take Full backups every night so, applying a diff backup is out of question for us. Also, i have restored the secondary using a new backup of the...

Gail,

No, the primary has not been restored from a backup.

The Primary DB was offline for less than 1 minute.

There were no interruptions for the LS_Copy or LS_Restore jobs.

The primary DB state change occurred at around 10:00 local...

The LS_Restore job has been failing with this error:

"Error: The log backup file '\\ServerName\DBNAME_db\DBNAME_DB_20121203221511.trn' was verified but could not be applied to secondary database 'DNAME_DB'.(Microsoft.SqlServer.Management.LogShipping)"

"Error: This backup set cannot...

Thanks Robert.

For SQL 2005 install i remember seeing the SQL Server service account in these groups. But for SQL 2008 install the account seems to be missing.

I have tested the uninstall\reinstall of .Net framework on a test server and it didn't affect the SQL Server Instance\databases. However, i didn't have to do that reinstall on the...

Thank You.

I have been using this site http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx, but was wondering if Microsoft hosts a similar one with a more up-to-date and detailed info.

Ashwin,

the default backup directory for my SQL instance is Q:\SQLBackups.

If you look at the error, it says that the path 'Q:\SQLBackups\Q:\SQLBackups\QAS\QAS.BAK'. is incorrect...

So, it looks like SQL Server is...

Q is a local drive.

I don't think it is possible to backup the directory where you have your mdf and ldf files, unless you have something like SQL SNAPS software.

So, it is your...

No, not at all. If you have the reindex job once a week or a month then it would...

Ravi, our trn files hover between 100MB and 500MB every hour. If I shrink my ldf to 12GB, does this mean that I have 12GB to grow each hour, before...

What are the scenarios that I am looking at if I shrink the file again, only this time, setting the target size to 12GB? In other words, what are the...

Cathy,

We have good information in the BOL regarding this:

Shrinking a log depends on first truncating the log. Log truncation does not reduce the size of a physical log file. However,...

Cathy,

DBCC SQLPERF(logspace) will give the percentage of the log file currently occupied with log information. The percentage value that you may see for a particular database will depend on...