backup database bnsdavgps to disk = 'D:\MS SQL Databases\Data\bnsdavgps.bak'
RESTORE FILELISTONLY FROM DISK = 'D:\MS SQL Databases\Data\bnsdavgps.bak'
--GpsMelissaDPS
--GpsMelissaDPS_log
RESTORE DATABASE BNSDAVGPSNew FROM DISK = 'D:\MS SQL Databases\Data\bnsdavgps.bak'
WITH REPLACE, File=1, Norecovery,
MOVE 'GpsMelissaDPS' TO 'D:\MS SQL Databases\Data\bnsdavgpsnew.mdf',
MOVE 'GpsMelissaDPS_log' TO 'D:\MS SQL Databases\Data\bnsdavgpsnew_log.ldf'
Friday, October 8, 2010
Subscribe to:
Post Comments (Atom)
Demystifying Kubernetes: Scaling, NodePorts, and the Myth of the "Chosen Pod"
Kubernetes has become the de facto orchestration platform for modern cloud-native applications. While containerization platforms like Docker...
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
-
CONCLUSION : 1. Normally, use following two when you do not want query compilation also to come into picture. CHECKPOINT DBCC DROPCLEA...
-
Most of the Google tutorials on Keras do not show how to display a confusion matrix for the solution. A confusion matrix can ...
No comments:
Post a Comment