Viewing 14 posts - 16 through 29 (of 29 total)
Where? I don't see that option, except for legacy DTS packages, but this isn't a legacy package.
October 26, 2005 at 7:05 am
I couldn't find anything in the documentation, except for the DTUTIL command line utility, but I can't get that to work!
October 25, 2005 at 2:07 pm
OK. There is no 'logging' of the DDL that would need to be removed.
October 25, 2005 at 10:48 am
I'm not sure I understand your question. Are you questioning the 'Recovery Model' properties for a database, which will determine what is in the database log file. Or are you...
October 25, 2005 at 9:36 am
How about this one....a long, long time ago.
We had a data entry system, lots of people hammering away, entering data. All going into 1 file on a mainframe.
Everything worked fine,...
October 25, 2005 at 9:22 am
As far as I know EM does not retain any history of what you did. You just have the final database, thats it! Nothing to delete.
October 25, 2005 at 9:09 am
You definitly can append without using a device. I do it all the time.
October 21, 2005 at 2:19 pm
How big is the database?
My test showed no difference in the size.
Is the device and the file on the same drive?
October 21, 2005 at 2:05 pm
Could it be you already have previous backups in the file, but you only just created the device? I see you are using NOINIT which just adds the new backup...
October 21, 2005 at 12:48 pm
I run this....
CREATE
procedure usp_HelloServer
@ServerName nvarchar(128)
as
declare @isql nvarchar(255),
@rc int
set @isql = 'osql -S' + rtrim(@ServerName) + '...
October 20, 2005 at 11:46 am
I just tried and was not able to do it.
restore headeronly from disk='d:\stage\GLYNNE_backup_200510131516.bak'
gave me the following error;
Server: Msg 3205, Level 16, State 2, Line 1
Too many backup devices specified for...
October 20, 2005 at 9:32 am
Viewing 14 posts - 16 through 29 (of 29 total)