May 9, 2011 at 11:13 pm
I wants to get a copy of a db from another server . in sqlserver 2008 I choise copy database but when I face to below form, I don’t know what I must do for file share containing.
the picture is in attachment
May 10, 2011 at 12:17 am
How much database size ? best way is to take a backup and then restore on another server
you have to define the sharing path of the source database files as
\\yourservername\c$
or
\\yourservername\dbfiles
sharing must be enable on the folder dbfiles
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 10, 2011 at 12:23 am
but source bank is sqlserver 2000 and destination is sqlserver 2008.
therefor by backup and restore . it can't be done . system give error.
what is the solution?
May 10, 2011 at 2:36 pm
armm1388 (5/10/2011)
but source bank is sqlserver 2000 and destination is sqlserver 2008.therefor by backup and restore . it can't be done . system give error.
what is the solution?
It can be done as long as you're not trying to restore a system database. Here's how you would do it:
1. Backup database from SQL 2000 instance. Backup command reference for SQL 2000: http://msdn.microsoft.com/en-us/library/aa225964(v=sql.80).aspx
2. Restore the backup to your SQL 2008 instance. Restore command reference for SQL 2008: http://msdn.microsoft.com/en-us/library/ms186858.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2011 at 8:25 am
The only thing that you will not be able to do is backup the SQL 2008 server to the SQL 2000 server, however,
You will be able to use transactional replication to replicate your data to the SQL 2000 server if need be.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply