Questions: While taking the Db Dump, was your application doing any transactions into the database.

is the applicaiton or client running some set statemetns diff from the default READ COMMITTED isolation...

you can try this:

Can the client connect using IP address of this SQL server.

on Client Machine:

Start->run->cliconfg

add TCP/IP in Alias tab and specify the IP of this Database Server.

save and close.

in...

see if this helps:

http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf

I think this question was already posted on microsoft site... some where...

Maybe the 2000 Libraries used by code are not compatible with 2008 server.. or something.

Edit: Found the link:

see if this helps:

http://support.microsoft.com/default.aspx/kb/933265

locally where the the express edition is installed and is in question, can you open the configuration wizard and enable the Protocols (TCP/IP). then try to connect:

LEt me know if...

will you be able to post the error message..

akhil,

As you mentioned 8GB with SQL StD Edition. What is your base OS like (Windows Standard or enterprise 2003)

with a windows Standard 2003, SQL is still able to use the...

paul is correct, i completely forgot about that.. i should stop thinking about my girlfriends all the time. 😀

But, when you right click and start the job, does it work or throws error..

were you ever able to connect?

start->run-> type with quotes "cliconfg"

on right side box check to see both the named pipes and TCP/IP are enabled.

Goto Alias TAB

check to see if the...

Named instances with the same instance name but different servernames.. correct?

Check the job properties and check the owner.. give a valid account.. like a SA or the saem account the...

so you want to create a secondary Datafile (.ndf) and create new table(s) to ndf.

that is easy. But it would a good practise to add a filegroup and then add...

Yes you can copy/Export Maintenance plans across SQL Servers.

Maintenance Plans are SSIS Packages.

Connect to Server->Integration Services.

goto MSDB-> under MSDB there should be a folder named Maintenance plans.

Expand the Folder.. and...

what is you server configuration and versions:

SQL Server (2000/2005) Edition/service pack

OS version/Edition/Service PAck

Hardware configuration(Memory/CPU/DISK)