Perl validating file names virgin births predating jesus
The destination server does not have a D drive, and you want to restore the database to the C:\Mssql\Data folder. The job was requested to start at step 1 (Kill connections).Good luck Many thanks for that it seems to be what i was after however i keep getting an error - The job failed. here is the scripting i have; kill connections - ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE Restore - RESTORE DATABASE FROM DISK = 'E:\folde\ .bak' WITH MOVE 'Logical_Name_Data' TO 'G:\SQLDATA\MSSQL\data\ _Data. -- Erland Sommarskog, SQL Server MVP, es****@Books Online for SQL Server 2005 at Online for SQL Server 2000 at Apologies here is the info Executed as user: User domainname\user.Hi, I am planning to automate a nighty restore of a DB on another server can someone point me in the right direction with the SQL script to modify the logical file names to the correct path and not the ones carried over with the DB??
LDF', STATS = 1, REPLACE GO i get above error as stated, any help much appreciated does anyone actaully have this working?? cheers This is so frustrating, i have tried numerous variations and always get the same error can any one help??
Validated files are cached for one hour and then deleted. You can either clone the repository or download it as a tar ball.