GRANT BULK INSERT ON [TEMPDB] TO [User]

would work wouldnt it? .. granted I don't know enough about tempdb to know how destructive something like this could be 😉

• This reply was modified 5 years, 6 months ago by  oogibah.

While I don't know the answer to your question specifically.. a word of caution.. if you're not on SQL Server 2016 CU7 or SP1 CU4 .. compression + encryption can...

It just depends on the nature of the table.. if I can avoid deleting data I prefer to do it another way, whether that is checking if the table already...

.. or using

I hate using truncate/deletes.. granted .. not sure if your account/service account will have access to sys tables

IF NOT EXISTS (SELECT name FROM database.sys.tables where...

• This reply was modified 5 years, 7 months ago by  oogibah.

The issue here though didnt actually end up being the quoting, although I did ultimately end up quoting everything.. its that with powershell robocopy you apparently cant end folder desitnations...

welp.. nevermind.. finally found a forum post that helped.. apparently powershell robocopy doesn't like you to end your folder paths with a \ .. moved this and quoted everything.. worked...

just to notate this too.. I tried using commas in my final attempt to try to get this to separate ..it didnt work obviously... I did not have the commas...

There is also the Accidental DBA series that is pretty solid on SQLSKills

https://www.sqlskills.com/help/accidental-dba/

Looks to me that either your database log file has somehow been deleted or your database no longer have access to it... which wouldnt make any sense.. If I remember...

I am rather new to SQL myself, but I feel differently.  If you're just starting out, don't already have a job that allows you to work with SQL I feel...

Good call, Thanks

This might be network related, when you ping the alias does it come back with the proper IP address?

Still learning SQL stuff here, what is the problem with turning ansi nulls off.. I see it in a ton of SPs?

For sure, it sucks when stuff like this happens but a good boss will be understanding and happy that you owned up to the mistake and let them know about...

Quite a few people use Ola Hallengrens solution for this, if you google that name it will come right up.. just schedule the job to run during your maintenance window...