first thing i would suggest have sufficient disk space for the databases.......you can schedule the backups in the off bussiness hours so that i would not cause any performance problems......if...

if you want to remove your mirror db you need to remove mirroring first and then only drop the mirror db........

alter database dbname set partner off

will turn off the mirroring now...

sql 2005 doesnt show the suspect status in the object expplorer......,try this but i am not sure....

select databasepropertyex('DBName','Status') ..............

whats the error you get while restoring the user dbs ? ?...

refer this link for the version and edition upgrades,

http://technet.microsoft.com/en-us/library/ms143393.aspx  you cannot downgrade from enterprise to standard without uninstall and reinstalling sql server 2005.........but vice versa is possible..........

unless you specify a cleanup task in the maintenance plan will not remove the old backup files........go to your maintenance plan and right click and modify and see if there is a...

just check in the log shipping monitor and see what is the last tran log that was restored??? if nothing was restored from the time of configuring the log shipping...

to avoid data loss you need to have full recovery model,as it logs the transactions fully....but the size will grow enormously in case of bulk insert operations......hence it is advisable...

refer this link, you need to have XP with SP2 but you cant install enterprise edition in it.....

http://technet.microsoft.com/en-us/library/ms143506.aspx

you can run the sql profiler in sql 2005 and monitor the bottlenecks in sql server....refer, http://technet.microsoft.com/en-us/library/ms181091.aspx

Matt,Jus do as below,

1.tran log backup on primary server falls into a shared folder

2.the sql service account of secondary shud have modify privilege for that shared folder,so that copy job...

inaddition to what sugesh said, you can't configure db mirroring from sql 2000 to sql 2005 as it is not available in sql 2000...........the following are the editions supported in...

hi you can remove mirroring as pointed out by earlier persons,now whats the error you are getting......alter database command cud work

just refer ,

http://deepakinsql.blogspot.com/2007/07/how-to-configure-database-mirroring.html - for configuring dbmirroring

 http://deepakinsql.blogspot.com/2007/07/prerequisites-for-database-mirroring.html - prerequisites for mirroring

revert if you have nay concerns

yes you can make use of that code...

just insert from tape into disk and give a try.......and start sql in single user mode....

net start msssqlserver \c \m and check if its working.....

dont ever shrink the system dbs except tempdb......but i wonder how your master is 750MB it shud be less than 100MB....check and remove all user tables if any from the...