Use this script to restore a SQL back up as in a different name and location
RESTORE DATABASE Database name.bak
FROM DISK = N'x:\Backup_name_backup_201408081200.bak'
WITH
NOREWIND,NOUNLOAD,STATS = 1 ,
move 'Database name' to 'c:\New Database name.MDF',
move 'Database name' to 'c:\New Database name.ndf',
move 'Database log file name' to 'C:\log_files\New Database log file name.LDF'
GO
Subscribe to:
Post Comments (Atom)
Passwords Made Easy
Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
-
If you have a situation that requires an application to always be up then try Restart program after a crash downloadable from https://w-s...
No comments:
Post a Comment