Query to Copy Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Query to Copy Database

Author

Topic

Naveed88
Starting Member

19 Posts

Posted - 2009-04-21 : 05:49:21

Hi All !!

i need to copy my database
and Empty some of tables from them
with resetting their Identities to 1

I m doing it manually
But i m sure there is better way to do this by writing a query

1- Restore Database from file
2- Restore Database from another databse

thaks for anu help

(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´ & Programming
Regards....
"Deevan" [Naveed Anjum]
Web Developer,9867374437-Mumbai.4

Rajesh Jonnalagadda
Starting Member

45 Posts

Posted - 2009-04-21 : 08:35:56

Try this,

1. RESTORE DATABASE AdventureWorks
FROM DISK = 'Z:\SQLServerBackups\AdventureWorks.bak';

2. RESTORE DATABASE TestDB
FROM AdventureWorksBackups
WITH MOVE 'AdventureWorks_Data' TO 'C:\MySQLServer\testdb.mdf',
MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\testdb.ldf';

Rajesh Jonnalagadda
[url="http://www.ggktech.com
"]GGK TECH[/url]

Naveed88
Starting Member

19 Posts

Posted - 2009-04-22 : 00:00:28

Thanks
it works

(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´ & Programming
Regards....
"Deevan" [Naveed Anjum]
Web Developer,9867374437-Mumbai.4

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources