distinct Posted October 31, 2013 Report Posted October 31, 2013 iam trying to take back up of a database .the path where the back up file need to be saved has .trn extension. do i need to take both with .trn and .bak or do i need to change that extension to .bak
gupta24 Posted October 31, 2013 Report Posted October 31, 2013 If there is an extension with .bak then if u want to take a backup with .trn just erase that .bak and give .trn over there. u need not take two backups for both extensions.
distinct Posted October 31, 2013 Author Report Posted October 31, 2013 actually i have to take a backup of a database .by default when i hit on backup it gives a default path which has .trn extension ,my question is like do i need edit the path to .bak else do i need to take 2 times back up one with .bak and .trn
gupta24 Posted October 31, 2013 Report Posted October 31, 2013 Yes, u need to edit the backup path to .bak. U need not take two times backup for both the extensions.
distinct Posted October 31, 2013 Author Report Posted October 31, 2013 I have taken back up of a database and i Have to restore it in another server so whem am trying to create a new database i got the following error what might be the reason CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider)
edisav_edava Posted October 31, 2013 Report Posted October 31, 2013 trn is transactional backup while bkp is full backup.....i wud suggest full bkp unless requested by client
distinct Posted October 31, 2013 Author Report Posted October 31, 2013 trn is transactional backup while bkp is full backup.....i wud suggest full bkp unless requested by client Thank you,
distinct Posted October 31, 2013 Author Report Posted October 31, 2013 I have taken back up of a database and i Have to restore it in another server so whem am trying to create a new database i got the following error what might be the reason CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider)
Spartan Posted October 31, 2013 Report Posted October 31, 2013 I have taken back up of a database and i Have to restore it in another server so whem am trying to create a new database i got the following error what might be the reason CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider) Where did u place your .bak file.. it should be under backup locaiton which opens up by default when u browse for it.. or else it will throw up that error... also check you have write permissions on the C Drive/System drive of that new server.
edisav_edava Posted October 31, 2013 Report Posted October 31, 2013 ni exact requirement cheppu, we can suggest whether to take a .trn or bkp backup
Recommended Posts