how to make a duplicate database with new name in SQL Server 2008
-
i need to make a duplicate copy of an existing database with a new name in sql server and this has to be done using QUERY ONLY, i tried to take a backup and restore but that restores with the same name...
-
i need to make a duplicate copy of an existing database with a new name in sql server and this has to be done using QUERY ONLY, i tried to take a backup and restore but that restores with the same name...
-
thank you that worked for an extent, but still finding a bit of problem when trying to restore the database from sql query using c# in asp .net
-
thank you that worked for an extent, but still finding a bit of problem when trying to restore the database from sql query using c# in asp .net
when i try to restore it says the mdf file location is in correct but when i try to run the same query in sql it works perfectly, any idea on what iam doing wrong.... also how do i know the logical name of the db, since i will be restoring it in the runtime i cant afford it to come randomly, when i tested sometimes it comes as master and mastlog and sometimes it comes as the db name i have backed up...
-
i need to make a duplicate copy of an existing database with a new name in sql server and this has to be done using QUERY ONLY, i tried to take a backup and restore but that restores with the same name...
nvarunkumar wrote:
QUERY ONLY
Why? That is a rather inefficient approach...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
nvarunkumar wrote:
QUERY ONLY
Why? That is a rather inefficient approach...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
because i have backup and restore at runtime in asp .net, so if i get the query i can put it in sqlcommand in asp...