Derek,u can have both 2k and 2k5 in the same server.since u had 2k already it wud have been a default instance,so u jus need to install 2k5 as a...

hi,is there enuf space in the drive where model dbs files resides??? refer http://support.microsoft.com/default.aspx?scid=kb;en-us;317375&Product=sql2k fyi.........u'll get to know the cause

just a small modification to what i said, the command is net start mssqlserver /c /m /T3608........if we use net start command we shud use / instead of -.......

refer the...

did u check the error log??? if s pls let us know what error was reported there....try starting the sql server in single user mode....in cmd prompt type as follows.......net...

sounds interesting,ensure u change the originating_server_id column in the sysjobs system table...do revert with your results once u perform it successfully so that we will know the steps.....

Hi,fyi http://technet.microsoft.com/en-us/library/ms143799.aspx jus check if this is wat u want?????

Hi Wayne,

yes you are absolutely right......the tran logs contains only the transactional changes made since the full backup in ur case after 9;00 full backup 1st trn is @ 9:45 so...

Hi John,

         Refer the below link,seems to be similar jus revert back if you need any help..........cool

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=376461

Hi Derek,

           There are 2 types of upgrades you can perform namely,

inplace upgrade and side by side upgrade.....In inplace---the existing SQL 2000 will be replaced by SQL 2005,you need to...

hi david,

           ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/e02b2318-bee9-4d84-a61f-2fddcf268c9f.htm fyi.......give both the parameters

hi,

   are you sure all the tran logs are available because if any of those is missing,maybe someone would have deleted by mistake in that case also the restore job would fail.for...

Hi pls check http://www.sql-server-performance.com/ss_creating_backup_jobs.asp fyi

just check which tran log was not restored and check if exist in destination servers folder where tran logs are copied,if exists then check the monitor server why didnt restore...

jus check manually in the folder where the tran log backup of log shipping db is falling and chek the time wen it happened,and also ensure tat the same trn...

hi,fyi ....

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/b8752ecc-db45-4e23-aee7-13b8bc3cbae2.htm