er.....not sure what happened there........

Michael,

thanks for that.

DevDBAs will not need to stop/start services and local admin on the server will definitely be out.

Can you expand on the permissoins needed to...

Michael,

quiesce replication, make sure all transactions have reached the subscriber, backup up subscriber and restore with move option to new file locations (and reset dbowner if necessary)

Liam,

select nt_username from master..sysprocesses

will give you their individual id even if access id granted through group. alco column ny_domain if you need that.

HTH

george

there is a cumulative hotfix 2187 after SP4, have you applied that. not sure of all the bugs it fixes but worth a check

http://support.microsoft.com/kb/916287/

Peter, haveyou tried the -T option to connect with your windows id, then you will not need to enter your password.

george

run the following:

/* code to determine actual SQL when DBCC INPUTBUFFER returns

  code like sp_prepareexec:1

 replace spid with your actual spid value

*/ 

DECLARE @Handle binary(20)

SELECT @Handle = sql_handle FROM master.dbo.sysprocesses

WHERE spid...

I would have thought the only need to do this if is you do not have the space on a single drive to complete the backup, or you wanted to...

Paul,

as I said, give it a try, you will see. As eriK says all the log  cares about is the LSN nos are in sequence, and remember a full backup...

the maintenance plan runs a dbcc dbreindex for all user tables with the free space set to whatever you specify. If you set reporting tab to log to a file...

Kyle,

I came across this script I must have pinched off the web but have never actually used it so no guarantees!

--Use the master database

USE master

go

IF OBJECT_ID('dbo.spRoleMembers') IS NOT NULL

DROP PROCEDURE...

Hi,

I assure you you can restore tran logs 'through' a full backup without restoring the intervening full backup itself, otherwise how would log shipping work?

Kedar,

there is no sql native command to restore just one table or any other object from a SQL full backup, so what you require is not possible............unless anyone out there...

the OS is still the same so the rules for configuring memory still apply.

main difference in SQL 2005 vs sql2000 is standard edition can now take advantage of memory above...

I have done this the way noel describes and it works fine.

couple of provisos, script out replication first and stop the various cleanup jobs as well