Do this before the restore:

ALTER DATABASE yourdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Do this after the restore:

ALTER DATABASE yourdb SET MULTI_USER

Greg

As I said, open a SSMS query window for the named instance and run this

(substituting the name or your database and files):

RESTORE DATABASE MyDatabase

FROM DISK = '[backup file]'

WITH RECOVERY,

MOVE...

Franco,

You don't have to kick users out of the database before the backup, just before restoring from a backup. A backup can be done while the database is in...

Restore a backup in a named instance the same way you would in a default instance: either right-click on "Databases" in Management Studio and select "Restore Database..." or use T-SQL...

I can't tell what caused the failure from what you've posted. If you could enable package logging in the DTS package and post what that shows after the next...

Jai,

Your restore sequence should work as long as translog1 backup and translog2 backup occurred after the differential backup.

For restoring a SQL 2000 database, you can use either SSMS or Query...

Hi Gene,

What happens when developers try to save packages. If it's the same problem as described this this thread: http://www.sqlservercentral.com/Forums/Topic405083-146-1.aspx#bm405192 , see Ed Vassies reply for a kb articles...

A NULL value is like any other value as far as the unique constraint is concerned, so only one row will be allowed with null in that column.

Greg

You could try granting INSERT permission to sysxlogins, but I don't know if that will work or if it's a good idea. Creating logins wouldn't do much good if...

The only link between jobs and packages that I can think of would be in sysjobsteps where the DTSRUN command is stored in the command column.

Greg

Congratulation!

I've been a member since 2001. I used to read Steve's, Brian's, and Andy's articles

at swynk.com and jumped to SSC when I found out they'd started it. I...

Hm. Do you have any custom tasks i.e. DLLs in the packages that need to be registered? Check out Ed Vassie's comments in this thread: http://www.sqlservercentral.com/Forums/Topic396124-5-1.aspx

NeoTokyo, I'm able...

Are you opening packages that were saved to SQL Server or are they files? I found that I had to save them as files and open them in SSMS...

Ninja's_RGR'us (9/24/2007)

---

That would be a great idea Steve. Can you tell us how the new point system works? Last time I checked, I only had 9600 posts or something like...

You could try querying msdb.dbo.sysjobsteps and search for the database name. Something like this where 'DBName' = your database name:

select j.name from sysjobsteps s join sysjobs j on s.job_id...