xp_fixeddrives

Very good article. #10 is a very good idea for me.

I would like to highlight #4 security plus database auditing requirement and GRC (Governance, Risk and Compliance).

I...

Good article about the tasks a DBA needs to do. I have a couple add-ons:

* is DR in place? recovery plan/document/script ready?

* restore verified?

* review user access

* what...

Thank you Steve for your reply.

To clarify, there are 2 logical drives/LUNs, not physical drives.

There are a lot of tempdb usage. Tempdb has 1 data file only. I...

Maybe I should put the question this way.

What are the considerations when evaluating/deploying a database administration tool in your enterprise environment?

My thoughts are:

1.research the market

2.read document

3.trail version

4.contact vendor...

Right. Remote server is for backwards compatability. Starting from 7.0, linked server is recommended.

http://www.sqlservercentral.com/articles/Distributed+Queries/linkedserver/139/

http://www.sqlservercentral.com/articles/Distributed+Queries/anintroductiontolinkedservers/1366/

Log shipping is set up to restore log from one SQL server to another SQL server no matter either SQL server is on a stand-alone server or on a virtual...

For "...check if Target Table B has any records; if no records...", I would use select top 1 columnname from the table and check rowcount = 0 or not to...

I had the same problem and am planning to apply SP4 2187. I saw other user had the same problem with 2187 so I am questioning whether there is...

Christopher, What is the hotfix for this?

You may have to shrink DB to release some free space if you have critical disk space issue.

But I would do the following:

1. Is the database size expected?...

I have collected some info about this error a month ago. Share with you here. I do not know your server setup and activities at that monment. ...

You may use "Filter Columns" to get the columns you need from each table and join the filtered tables on the subscriber using a query/view.

Right click your publication -> Properties...

For your reference:

The databases in a log shipping configuration must use the full recovery model or bulk-logged recovery model.

http://msdn2.microsoft.com/en-us/library/ms188698.aspx

Any detailed error message? I checked Quest KB, it says...

-------------------------------------------------

Backup error message: "Server: Msg 62309, Level 19, State 1, Line 1"

Problem DescriptionError:

"BACKUP LOG is terminating abnormally when...