Hi,

I am sure security is the main cause in your case.Up to my knowledge you need to have Integration services to be installed to get ur maintanence plan works properly.

Hi,

Why don't you try simple windows copy command using universal naming path?I tried that way for our db and it worked pretty well for me.

Hello,

Its a bug of SQL server.Most of cases it fails with deletion and optimization (or) integrity checks of database in maintanence plan.

Regards,

Sireesh

Hello,

I am not sure How to do this in SQL server,But In our environment we are using batch file to call vbs file and executing that batch file using windows...

Hello,

You don't have to use provider string and other stuff If remote server is SQL Server and problem with your linked server sounds like authentication problem.Up to my knowledge...

Hi,

I guess this one should help you.

BACKUP LOG [datebase name] WITH NO_LOG

DBCC SHRINKFILE ( 'databasename_log', truncateonly )

simply DBCC SHRINKFILE won't help you u need to backup log first and then...

Hi,

I am anticipating all the servers in one domain than you can execute psexec from command line for that you need to have psexec tool.You can google about this psexec...

Hi,

I am sorry its my bad,I didn't read ur full question.I thought you want to fix particular user later I realised it is for all users at one time.

Regards,

SC

Hello,

Their is simple way to do that stored procedure sp_change_users_login 'report' will give you all orphaned users from your server and if you want to fix particular user say 'user1'...

Hi,

I am expecting you connected linked server to your server succesfully.

Query will be like this select * from openquery ([linkedserver1],'select * from db_name.master.dbo.table_name')

Hi

I would like to add two things to your list

1)orphaned users

2)Did you take care of T-SQL changes.

Wish you good luck..........

Hey,

Only thing I could imagine of this problem is make sure TCP/IP is turned on.

Hi alnguyen386,

I have done migration for nearly 20-30 databases.I did with backup and restore method.You need not to worry about the data,restore will takecare about that data,stored procedures,Triggers,Functions.Some of the...

Nicole

This might help you:

http://msdn.microsoft.com/en-us/library/aa337361.aspx

Regards

SC

Hi Nicole

Only problem I could think of your case is TCP/IP.Make sure TCP/IP enabled on both the servers

SC