Activity overview
Latest activity by DanMoran
Log-shipping: "Restoring" instead of "Standby/Readonly"
This works -- when done calling it, I get my database restored as "Standby/Readonly" and I can access the tables within it.
EXEC master..sqlbackup
'-sql "RESTORE DATABASE CALL FROM DISK = [h:\db\re...
Two scenarios -- when I explicitly grant the startup account full rights to the backup folder, I get:
<SQBUTILITYRESULT>:1:
When I grant full rights to the group "sql users" and add the startup account to that group, I get:
<SQBUTILITYRESULT>:0:Insufficient rights to read folder : The operation completed successfully. Insufficient rights to create files : Cannot create file "f:\db\backup\sql backup test 20110505110029228.txt". Access is denied.
It appears my group level permissions aren't persisting through to the startup account ... / comments
Two scenarios -- when I explicitly grant the startup account full rights to the backup folder, I get:
<SQBUTILITYRESULT>:1:
When I grant full rights to the group "sql users" and add the startup acc...
Thanks. I suspected this was the case, but wanted to be sure. / comments
Thanks. I suspected this was the case, but wanted to be sure.
Interoperability
Can I backup a Compatability Level 9 DB from a 2008 SQL Server, using SQL Backup, and restore it as is to a SQL Server 2005 box?
Permissions problem - Warning 200
My server is fairly locked down; it caused problems on installation. Now it's causing problems on backup -- I'm failing to backup to the directory I'm aiming at, with the error:
Warning 200: Error ...
That got it. Many thanks. / comments
That got it. Many thanks.
Installation Failure
Installing 6.4.0.56. App installation appeared to go well; when I attempt to "Install or Upgrade Server Components..." I get the errors appended below.@version returns:
Microsoft SQL Server 2005 - ...