Hi Diane,

I've done exactly this, LAN to DMZ, by doing what Homebrew01 said - using identical SQL logins to configure the linked server. In some cases I've needed to...

Hi Andrew,

Did you install the tutorials from the SQL Server 2008 media? If not you can find them here: http://msdn.microsoft.com/en-us/library/ms167593.aspx . The first one covers...

Go to Start, Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager and select SQL Server 2005 Services. Right click over SQL Agent and select Properties. ...

As Krishna and I have said, it's not possible to back up tempdb. If you run

BACKUP LOG TempDb (as Adiga suggested)

you receive the error

Msg 3147, Level 16,...

Hi,

You're getting that error because tempdb can't be backed up. If you do a search in BOL for tempdb it'll explain why.

Is your login a member of the Windows Local Administrators group on the server? If so, that's where the problem is, as the BUILTIN/Administrators' permissions in SQL Server ...

Hi,

Have you considered log shipping from Server A to Server B? You could schedule that to run in the early hours of the morning when things are...

If your DB is in Full and is accessible, it sounds like what you need to do is to perform a tail log backup - ie run a transaction log...

Have you tried logging in to the dev's workstation and registering the server with your credentials? Can anyone else in that AD group register that server?

On my first day as a dba my manager told me that the better a dba a person is, the fewer people know their name. I know what he...

Hi,

I think this will do what you need:

http://www.specialopssecurity.com/labs/sqlrecon/

as long as you have the appropriate network permissions. It uses various methods of detection (configurable) and does more...

I wouldn't switch my firewall off on either side ... If you want to do that, definitely make sure someone senior gives you the go ahead - preferably in...

It's not in SS2K5. You need to use the setup.exe on your installation media.

Not being unfriendly, but you could have googled that and got the answer much faster than...

Hi,

Yes, you can have a column with a different collation from the table, but it can be problematic, especially round tempdb in my experience (though not my database). Look...

Hi,

This sounds like connection pooling, which is how a lot of apps access SQL Server. If so, this is how it's supposed to work, so unless you're certain it's...