copy database

Question

copy database

surma.sql

SSCommitted

Points: 1552
More actions
April 30, 2012 at 1:27 pm

#273437

hello
I copy database from one server to another server.
my source database size is 350 MB. when i am done with copy database from copy wizard, the destination database size is 950 MB.
i am wonder why there is huge difference in size?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Try doing a backup and then a restore instead of the copy db wizard. I have never used it and didn't even realize it was an option until just now. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

surma.sql SSCommitted Points: 1552 More actions · Answer 2

so can you give me backup t-sql

because i have to backup from allg-ad1-dc server

and when i try to take backup it throws error

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

What is the error?

This will explain the backup database command far better than I could. http://msdn.microsoft.com/en-us/library/ms186865%28v=sql.105%29.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

surma.sql SSCommitted Points: 1552 More actions · Answer 4

this is command that i am using

backup database sasixp

to

disk ='\\10.15.1.40\d$\sasixp.bak'

i need to store on 10.15.1.40 server

this is error

Msg 911, Level 16, State 11, Line 1

Could not locate entry in sysdatabases for database 'sasixp'. No entry found with that name. Make sure that the name is entered correctly.

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 5

The database name you put in isn't there. Either there's a typo or you're on a case sensitive install. Try putting the name in exactly as it appears in SQL Server Management Studio.