ест" 2 сервера , мне надо скопироват" базу с одного сервера
на другои сервер

как ?
помогите пож

probyu tak :


1. Open Enterprise Manager
2. Tools -> Data Transformation Services -> Export Data
3. This opens a wizard.
4. Pick a data source
5. Pick a destination
6. Check the different options you want.
7. Click Finish

The only problem I had was if a User had permissions on an object in DatabaseA, but the User didn't exist in DatabaseB, I would get an error message. I had to duplicate the Logins first before I could transfer the objects.

sp_attach_db chrevata problemami ....