error code 3 is actually 'The system cannot find the path specified' rather than a permissions error.

its not possible to omit the log from the restore, What exactly did you...

try this

-- run this script from the user database

--exec usp_get_object_permissions

--drop proc usp_get_object_permissions

--go

create PROCEDURE [dbo].[usp_get_object_permissions]

@as_objectname sysname = null /***Object Name to check, if null then all objects***/

AS

set nocount on

set quoted_identifier off

--drop...

what you describe is impossible.

If you have been using the GUI to do the restore it has renamed the files for you based on the database name.

In TSQL run sp_helpdb...

heres a nice little script for the object permissions I just found. I will start off with this and build the rest around it.

http://www.sqlservercentral.com/Forums/Topic453290-146-2.aspx#bm534643

The DBA could just script out the database from SSMS and include object permissions, but I understand that can be slow.

I think the issue here is preserving the users and permissions from the test database before restoring over it, and of course losing the existing permissions.

Tables you need to look...

to be able to use the replace option and overwrite the existing database to the existing file locations the logical file names and no of files must match.

Run restore filelistonly...

you would have to offline the database, use alter database modify file, physiacally rename the file, then online the database again.

so the database won't be detached but you will need...

the restore will fail. Use the with move cluase to move the physical files to a different location.

automated alter database command?

no probs

its just the way the wizard works, it expects a share to be set up because normally the copy job on the destination server will need to be able to...

thats why we're here! 🙂

.....one thing I would do though whatever script you use is to exclude small tables from the reindex as there is no benefit from defragmenting them, so anything with less...