ok, thanks for reply...

could you give me solution and correct script for restoring. still i am facing same error.

Yes. I...

existing SQL 2000 file name and location like this format

TELE_Data D:\TELE Data Files\TELE_datafiles\TELE_Data.MDF ...

In Default instance showing like this

USE master

GO

xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc'

GO

Server is listening on [ 'any' <ipv6> 1433].

Server is listening on [ 'any'...

yes. I have installed named instance on same server which was already installed default instance MSSQLSEVER on that server.

After installed Both instances are connected with SSMS.

Default Instance - sllways connect...

1. What authentication method do you use for the applications?

SQL Server configured Mixed mode authentication, application using SQL authentication.

2. Windows or SQL?

Application connected with SQL user.

3. Will there...

Error code:

A Network-related or instance-specific error occured while establishing a

connection to SQL Server.

The server was not found or was not accessible.Verfy the instance name is correct

and the SQL Server is...

yes, understand these two commands

DBCC UPDATEUSAGE corrects the rows, used pages, reserved pages, leaf pages and data page counts for each partition in a table or index.

DBCC CHECKDB with DATA_PURITY

to...

Hi

Thanks for reply

New version - SQL 2K8 R2 enterprise edition with SP2.

Alreday tested with application with SQL 2K8 R2 test setup and compatible with SQL 2K8 R2. data files are...

Thanks you so much for reply from SQL Server Genius..GilaMonster,Steve Jones and Perry Whittle

1. If more then 200GB primary data file reached, I assumed need to create one more datafile...

Hi,

I executed at development server as below script but result is nothing.

please, Let me know what is the correct parameter using for whoisactive V11.?

use master

go

exec dbo.sp_WhoIsActive

thanks

I have done side by side migration activity not in same server, By using restored all existing database from SQL 2000 to SQL 2008 new setup. In this case existing...

Sean Lange (6/19/2012)

---

ananda.murugesan (6/18/2012)

---

by default installing SQL server 2008 or R2, Database Engine collation SQL_Latin1_General_CP1_CI_AS

Please confirm, can we changed SQL2000 collation at SQL 2008 database? if changed SQL2000 collation then...

by default installing SQL server 2008 or R2, Database Engine collation SQL_Latin1_General_CP1_CI_AS

Please confirm, can we changed SQL2000 collation at SQL 2008 database? if changed SQL2000 collation then SQL server 2008...

Thanks for reply

Option 2, Modified the boot.ini file as below

[boot loader]

timeout=5

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /3GB

Thanks

ananda