Viewing 3 posts - 1 through 3 (of 3 total)
Try it like this. When connecting to the server, force a Named Pipe connection. Afterwards, just do you're backup to the drive\path.
Instead of <servername>
try
np:<servername>
in the Connect To dialog box.
June 6, 2006 at 1:51 pm
#642127
Opps. Forgot to change the DB between cursor lookups. Edited to work on case sensitive collations, too. Try this one instead....
-- Wayne Fairless, DBA
USE
MASTER
GO
June 6, 2006 at 11:12 am
#642103
-- Try this. It'll go through all the DBs if no name is specified, otherwise, just -- return it for the DB specified.
June 6, 2006 at 9:17 am
#642041