still problems with database copy

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

still problems with database copy

Author

Topic

mdean9999
Starting Member

21 Posts

Posted - 2011-05-20 : 06:10:48

hi
I can copy small databases from online to sql server 2008 on my local computer.
I cannot copy one large database that I have. It churns away for a while and then fails.
The message from the event log is 'Creating a user without an associated login is not supported in SQL Server 2008'.
I setup a user on my local SQL server with the same id/password as the online database.
But this fails sooner with the following message.
What should I be doing to sort out the original problem?
Thanks
Michael
--------------------------------
TITLE: Copy Database Wizard

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E09 (The EXECUTE permission was denied on the object 'sp_ssis_getfolder', database 'msdb', schema 'dbo'.).

------------------------------
ADDITIONAL INFORMATION:

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E09 (The EXECUTE permission was denied on the object 'sp_ssis_getfolder', database 'msdb', schema 'dbo'.).

------------------------------
BUTTONS:

OK
------------------------------

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-05-20 : 06:52:21

How are you doing the copy?
Can you do a backup, copy file, restore?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

mdean9999
Starting Member

21 Posts

Posted - 2011-05-20 : 08:22:09

hi,
Using tasks, copy database from database hosted online with a service provider to my local computer SQL Server 2008.
Doing the same as the smaller database copies and they work, so I am a bit puzzled.
I shall investigate using backup and restore to see if i can get the db onto my local server
thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources