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.
Author |
Topic |
mdean9999
Starting Member
21 Posts |
Posted - 2011-05-20 : 06:10:48
|
hiI 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?ThanksMichael--------------------------------TITLE: Copy Database WizardWhile 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 serverthanks |
 |
|
|
|
|