Thanks,the database was set up like that and i am new with the company it's something i cannot change.

Any help?
Thanks

T

The delimiter is greyed out only row delimiter i can change.

Thanks Steve,so you mean all is well there is nothing i have to do since the key is embedded and this is not a trial.

Thank you so much,God...

Hi,
What is the output file saying my brother?Did this job ran before?

Thank you the new server has these specifications  sockets:2
                                          ...

Thanks Grant,

Yes 40GB is a lot but i am creating some partitions.I always archive the data the delete the partitions.I am still new to the Organization and i...

Thank you.if my DB grows with 40gb a week  what is a sensible growth in MB should i set?

Thanks in Advance

Thanks
@john-2, Yes the proc reads from a linked server and i tested the connection, it's successfull.
@ Han Shi , the proc doesn't contain "Execute As" Clause

Thanks William i will do so.

Thanks.It's on production and they create reports , do all ddl ,dml  commands  and we don't have a dedicated reporting or intergration server.it has been a year without a dba...

I am new in this Organization and no one to give me full info,all i can see is all the nodes are up but the host is A. Is this...

Yes the data is loaded in bulk through RabbitMQ

@Gila the server is ticked to compress backup on server properties.

@antony this code (select value_in_use from sys.configurations where name = 'backup compression default') does not...

@ VastSQL -  You mean its normal 850 GB mdf  to 160 GB. bak difference?

@Gila The backup is on the default server setting