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.
| Author |
Topic |
|
JANE123
Starting Member
3 Posts |
 Posted - 2011-12-08 : 07:38:44
|
| I've recently noticed if I backup manually via SSMS Tasks, under Destination the file to be backed up is showing as a .trn file. I had made a change in the last month to start backing up transaction logs and don't know if this is the reason I have .trn file extension here. For a manual backup I believe I want a .bak file. Would someone please tell me the best method of changing this so I get a complete backup when I have to manually back up the databases? I do have a maintenance plan set up which produces a .bak file daily and I have no problem restoring any of the databases.Thanks in advance for any and all replies!JANE |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-12-08 : 09:18:55
|
| Are you backing up to a backup device?----------------------------Junior DBA learning the ropes |
 |
|
|
JANE123
Starting Member
3 Posts |
Posted - 2011-12-08 : 10:29:11
|
Yes, to another drive on the server. quote:
Originally posted by chris_cs
Are you backing up to a backup device?----------------------------Junior DBA learning the ropes
JANE |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-12-08 : 11:27:58
|
| I imagine the device was created and the log backup was first so the device has an extension of ldf. I don't think this is a massive issue.I personally don't like using backup devices so I create separate files for each backup. I'm sure there are plenty of arguments for and against backup devices though.----------------------------Junior DBA learning the ropes |
|
|
|
JANE123
Starting Member
3 Posts |
Posted - 2011-12-09 : 07:52:44
|
| What changes do I need to make to have a full backup when using SSMS, Tasks--Backup? Before we apply windows updates I manually run backups and I don't believe I'm getting a full backup with a .trn extension. Please let me know if this is such a basic question that I should move it into the Forums for those new to SQL.JANE |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-12-09 : 10:50:34
|
| You could just use the backup command to perform the backup.BACKUP dbName TO DISK = '<PATH>'There is lots of information on this command in Books Online. If you choose to restore your database and choose the backup device it should list the separate backups. SSMS will tell you what type of backup each one is.----------------------------Junior DBA learning the ropes |
|
|
|
|
|
|
Manual backup via SSMS Tasks produces .trn file