Hi Alex,

  I don't use SQL Tape backups, but you should be able to use a query like this one to find the last backup for you database.  Then you...

Hi Chami,

  You can restore from another server by using the UNC path like:

RESTORE DATABASE TestDB FROM DISK = '\\OldServer\backups\TestDB.bak'

  Derrik already pointed out the WITH MOVE option for placing...

Hi Chami,

  From a more generic server to server move standpoint, here are a couple of things to consider.

1.  If the drive configurations on the two servers are not the...

Hi JV,

You can install Reporting Services without SSL.  I'm not sure if your second question is regarding whether RS or SSL can be harmful, but I'll assume

I think the troubleshooting steps already given will help you isolate the problem.

As a side note, SQL 2005 (Yukon) will have an SMTP based mail solution which will eliminate the...

There are 2 types of timeouts that you could be facing.  The first is a Connection Timeout, which only occurs when you open the connection to SQL Server.

The other, and...

BUILTIN\Administrators is added to the SysAdmin role by default when you install SQL.  Normally, <domain>\Administrators would be added to your <server>\Administrators groups.  In this case, all Domain Administrators should be...

How are you trying to Add the SQL Server to AD?  If you are using Enterprise Manager, it probably won't work.

The best way I've found it to use the SETSPN...

You should be able to run sp_helpsort.

Hi Lloyd,

  I did a little more digging, try granting select permission to the sysjobsteps table.  If that still doesn't work try granting execute permission to the sp_get_composite_job_info and sp_help_jobschedule stored procs...

Hi Lloyd,

  The targetserverrole group doesn't have access to the sysjobschedules table by default, which is where this information is stored.  You need to add select permission on the table...

Hi Atra,

  Looking at this error and the code you submitted, I would guess that you have not granted permission for the asdf login in the asfd database.  Further, it...

I just submitted a VBScript to the Scripts Library which will do this as well.  It is titled, Generate Strong Passwords for Standard SQL Logins, and should be available as...

We have set of scripts which we run via SQL Agent jobs to do our database and log backups.  They are designed to use either native SQL Server backup or...

I think Steve has probably nailed the issue.  However, it could also be a process that is taking the database offline or even detaching and reattaching it.  Hopefully, you would...