If the data files are in a different location, you need to specify the MOVE option also:
RESTORE DATABASE yourDatabaseNameHere
FROM DISK = 'x:\full\path\to\backup\backup.bak'
WITH MOVE 'logical_data_file_name'
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.