Perl validating file names
You need to find out what the names are, and there are two ways to do it: 1) sp_helpdb on the source database. -- Erland Sommarskog, SQL Server MVP, es****@Books Online for SQL Server 2005 at Online for SQL Server 2000 at I finally got this working so thanks for anyone else here is the script i used databasename should be the Database Name step 1 kill conections ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE step 2 restore DB RESTORE DATABASE datbasename FROM DISK = 'F:\backup\databasename.bak' WITH MOVE 'databasename_Data' TO 'F:\MSSQL\MSSQL\Data\databasename MDF', MOVE 'databasename_Log' TO 'F:\MSSQL\MSSQL\databasename.It's the first column in the second result set, just copy and paste into the single quotes. You can use this form to upload a sample manifest and validate it against the HICF checklist.Note: your uploaded file is not stored unless errors are found.i.e the database is to be renamed on the new server any help much appreciated Many thanks in advance This should point you in the right direction: If you restore the database to a different file location than the source database, you must specify the WITH MOVE option.For example, on the source server the database is in the D:\Mssql\Data folder.
You can then download a copy of this validated file using a link that will appear below.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.-- Erland Sommarskog, SQL Server MVP, es****@Books Online for SQL Server 2005 at Online for SQL Server 2000 at is so frustrating, i have tried numerous variations and always get the same error can any one help??RESTORE DATABASE [new DB name] FROM DISK = 'E:\Nightly backups Man1s\[Old DB name].bak' WITH MOVE '[Old DB name] _Data' TO 'G:\SQLDATA\MSSQL\data\[new DB name] _Data.