MICROSOFT SQL SERVER

Replicating data from SQL Server 2000 to Oracle

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1057950,00.html?bucket=ETA&topic=301335

Check BOL topic "Oracle Subscribers"

I believe you need to shrink data file not log file so you have to use the DBCC SHRINKFILE command to shrink data file also...

Use <dbname>

go

DBCC SHRINKFILE (fileid, FileSize)

See BOL...

If no recovery option is specified in your command then it defaults to WITH RECOVERY...

I don't see any problem deleted the db and restoring it...but you can restore on top...

Looks like your backup process was interupted so that it gave you incorrectly formatted error...

Just create a new backup WITH INIT option and use the new backup to restore...

Backup database...

http://uda.openlinksw.com/odbc/

http://www.datadirect.com/products/odbc/index.ssp

Take a look of the following article which may apply to your issue...

FIX: You may receive a "SQL Server could not spawn process_loginread thread" error message, and a memory leak...

How to Script User and Role Object Permissions in SQL Server

http://www.sql-server-performance.com/bm_object_permission_scripts.asp

I use the same article rthan mentioned article to transfer the logins...

Make sure you set default dbs correctly after moving logins...

Read the following tips for faster BCP...

Performance Tuning Tips for SQL Server BCP

http://www.sql-server-performance.com/bcp.asp

Perfmon can be configured using Virtual Server Name, so when you use virtual server name perfmon should continue after failover...

declare @objname Varchar(8000)

select @objname = ''

select @objname = @objname+object_name(id)+',' from syscomments where text like '%my text%'

and objectproperty(id, 'ismsshipped') = 0

select @objname = substring(@objname,1 , len(@objname)-1)

exec  ('drop proc '+ @objname )

select object_name(id) from syscomments where id = object_id('objectname')

Above query returns the object name even it is marked as comments...

http://msdn2.microsoft.com/en-us/library/ms345449.aspx

Did you kill the online indexing? how much time it took to rollback?

An assertion is typically raised when a program gets to a bit of C code that it shouldn't be possible to enter, or has been entered with wrong parameters. An...

It is almost the same as 2000..

Read BOL topic "Implementing Replication"