Viewing 15 posts - 961 through 975 (of 1,790 total)
Right click on the database > Tasks > Export Data. Go through the wizard to find your source, destination, etc and you should be good to go. Make sure that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 12, 2009 at 11:43 am
Mike, the solution that I mention will provide you with that. I don't know of any other way than taking that server out of the "mix" while doing the loading....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 12, 2009 at 11:41 am
Mike - not sure that I qualify for the "expert" criteria that you put in your post but I will share what we do. 😀
We actually have the instances both...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 12, 2009 at 11:35 am
You would have to use named instance in this scenario.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 12, 2009 at 11:29 am
Have you stopped and started SQL Agent service? That would be my first try. Second would be to copy the code from the step and make sure that it runs...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 12, 2009 at 5:25 am
Sorry, but I can't tell if you are stating that it is using the noise words in the search or it is ignoring them in the search. Either way though...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 12, 2009 at 5:20 am
Jeff Moden (1/10/2009)
Heh... of course, the simplest of all the solutions would be to do it all in T-SQL and perhaps a touch of BCP... SSIS not required. 😉
You...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 10, 2009 at 10:45 pm
The main reasons that I could think about keeping them together is so that you only have to maintain one schema and for manageability. However there are tools now that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 10, 2009 at 10:42 pm
Thanks Tim!
The message "A previous restore operation was interrupted and did not complete processing on file 'SL_Data'. Either restore the backup set that was interrupted or restart the restore...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 10, 2009 at 10:37 pm
Can you post the statement you are using? Is the last piece of your restore statement "NORECOVERY"? If so, then that is why it is staying labeled as "Restoring". However,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 10, 2009 at 9:59 pm
It seems like you should have done the differential restore while you were still in restoring mode. Example from BOL as follows;
RESTORE DATABASE AdventureWorks
FROM DISK =...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 10, 2009 at 9:26 pm
However, the greatest caution here is that you are basically doubling your activity for that instance for anything that is being replicated. If you are talking about infrequently used objects...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2009 at 3:11 pm
Maybe if you just post the link to the article about how to effectively post the OP will eventually get it. Maybe a bit like Tennis for while but it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2009 at 1:06 pm
Mani,
This is included in SP1 - http://support.microsoft.com/kb/913090
Sounds like this isn't the fix you were looking for. Sorry.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2009 at 12:16 pm
Avoid the shrink. That really is never the solution. More frequent log backups would be the best bet to keep the size in check. You can establish multiple schedules so...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2009 at 7:41 am
Viewing 15 posts - 961 through 975 (of 1,790 total)