Sql Back Up

[distinct]

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

[Vinuu]

help

[gupta24]

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]

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]

Yes, u need to edit the backup path to .bak. U need not take two times backup for both the extensions.

[distinct]

Thank you

[distinct]

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]

trn is transactional backup while bkp is full backup.....i wud suggest full bkp unless requested by client

[distinct]

trn is transactional backup while bkp is full backup.....i wud suggest full bkp unless requested by client

Thank you,

[distinct]

 

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)

 

 

[agora]

ltt

[distinct]

ltt

thankyou

[Avataar]

 lifting lifting  

[Spartan]

 

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]

ni exact requirement cheppu, we can suggest whether to take a .trn or bkp backup