Viewing 15 posts - 3,496 through 3,510 (of 6,397 total)
OS Error 5 is access denied, ensure that the account running SQL has the nessesary permission to the directory
November 5, 2012 at 5:01 am
Is the Oracle driver you installed a 32 bit driver or a 64 bit driver?
November 5, 2012 at 4:43 am
Better scenario is do not shrink the database at all, it causes a whole heap of potential problems and fixing them will only make the database bigger again, so you...
November 5, 2012 at 4:41 am
Seems like an error with the dot net framework, I would suggest re-installing
November 5, 2012 at 3:30 am
Restore database.
I never trust the GUI to do exactly what it says it is going to do, I prefer to do things in script, which is why that script button...
November 5, 2012 at 2:53 am
I just did a restore via the GUI and it did pick up the STOPAT date time I supplied. Strange that its not doing it on your side.
November 5, 2012 at 2:39 am
Yes on fail over if they are running as jobs then yes they will run as intended.
If you fail over and want to upload a new SSIS package you will...
November 5, 2012 at 2:33 am
There is the problem, the last log restore should specify the STOPAT clause detailing SQL where to stop restoring the log, you can manually add it in at the end...
November 5, 2012 at 2:28 am
Please look through the Windows logs for the reason why the SQL service errored while starting and post the results.
November 5, 2012 at 2:11 am
Run through the restore again in managment studio but instead of hitting run, hit the button at the top and script it to a new query window and post the...
November 5, 2012 at 2:09 am
What was the command that you used to restore to the point in time?
November 5, 2012 at 2:06 am
No, you can use the command line based tool instead to upload the package if you dont want to do it via SSMS, that way you wont need the SSIS...
November 5, 2012 at 1:49 am
You need to ensure that the account running the SQL server service has access to write to the unc path
November 2, 2012 at 11:10 am
Based on the code provided, the update is outside of the set @SQLCmd
Do you need the UPDATE to be inside the variable so that you execute the use and update...
November 2, 2012 at 8:30 am
You will need to manually create the backup command passing in the UNC path
Something like
BACKUP DATABASE database1 TO DISK = '\\SERVER\share\database1.bak'
You can manually type in the UNC path to the...
November 2, 2012 at 7:52 am
Viewing 15 posts - 3,496 through 3,510 (of 6,397 total)