I'll have to do some more research, but I seem to remember reading somewhere that TRY/CATCH in T-SQL doesn't catch all errors. I'll try and find where I saw...

James Raddock (6/5/2008)

---

Disagree. Each product release is finite and static.

I don't say I'm a SQL Server expert, I say I'm an expert at SQL Server 2005. Unless you know everything...

Nope. You have to start all over with the initial restore from your full backup.

😎

The extended stored procedure xp_getfiledetails no longer exists in SQL Server 2005. I just double checked my servers (I have both SQL Server 2000 and SQL Server 2005 still)...

Your code:

RESTORE DATABASE [db1]

FROM DISK = N'J:\SQLBackups\db1_backup_200805310215.bak'

WITH FILE = 1,

MOVE N'Reporting_Data' TO N'e:\Microsoft SQL Server\MSSQL\Data\db1.MDF',

MOVE N'Reporting_Log' TO N'd:\Microsoft SQL Server\MSSQL\Logs\db1_Log.LDF', ...

I got it right. When I read the question, I interpreted it to mean will the the two queries return the same result set. Obviously, some people read...

One thing I will suggest (strongly), test it in a test DB first to ensure it does what you expect.

Sometimes going off topic is refreshing. I've also seen it spark other thoughts and ideas. Sort of like stepping back from the trees so you can see the...

Backup the production database and restore it to your test instance.

😎

Do a search for this undocumented Microsoft stored procedure: sys.sp_MSforeachtable.

😎

Yes. REPLACE tells SQL to overwrite an existing database.

😎

Hit BOL (Books On-Line). If, after reading, you still have questions just post your question on SSC and I'm sure some one will help you out.

😎

You'll also have to secure the backup file itself. The file is not encrypted, and if the system admin can move the backup file to a local system (desktop)...

First, the while loop makes this code RBAR (a Modenism for Row By Agonizing Row). Also, it looks like it may have to do a table scan for each...

And here is my version:

set nocount on;

create table dbo.OrderHdr (

OrderID int,

FirstName varchar(25),

LastName varchar(25),

OrderDate datetime,

...