October 5, 2015 at 8:24 am
I do not see full backups in the specified Backup folder.
It does not make any sense?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 5, 2015 at 9:03 am
check in your recycling folder!
October 5, 2015 at 9:17 am
Quick questions, are the backups successful (check the log)? Any cleanup tasks scheduled or running? Is it the right drive?
😎
October 5, 2015 at 10:18 am
I did a couple of backups from the GUI and it named the file with a trn extension.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 5, 2015 at 10:48 am
Welsh Corgi (10/5/2015)
I did a couple of backups from the GUI and it named the file with a trn extension.
Are you certain those are full backups and not transaction log backups? Sounds very odd if full backups are suffixed with the transaction log .trn extension.
😎
October 5, 2015 at 11:43 am
You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the command to perform the backup from the GUI, script out the command it's getting ready to run. It will show you the full path so you can validate it is what you think it is. Also, don't confused if it says D:\, that's the D:\ on the server, not your machine.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 5, 2015 at 11:52 am
Grant Fritchey (10/5/2015)
You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the command to perform the backup from the GUI, script out the command it's getting ready to run. It will show you the full path so you can validate it is what you think it is. Also, don't confused if it says D:\, that's the D:\ on the server, not your machine.
Don't use the GUI that much but IIRC the GUI does use the appropriate extensions by type.
😎
October 5, 2015 at 1:00 pm
You can check in report, where was backup done RMB on DB->Reports->Standard Reports->Backup and restore Events or manually query msdb tables backupmediafamily and backupset
October 5, 2015 at 4:12 pm
Eirikur Eiriksson (10/5/2015)
Grant Fritchey (10/5/2015)
You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the command to perform the backup from the GUI, script out the command it's getting ready to run. It will show you the full path so you can validate it is what you think it is. Also, don't confused if it says D:\, that's the D:\ on the server, not your machine.Don't use the GUI that much but IIRC the GUI does use the appropriate extensions by type.
😎
Yeah, but again, it doesn't mean anything. Any extension can be used for anything.
I don't use the gui much either. I just tried it out. By default, it will create either a .bak file or a .trn file, but it doesn't seem too picky about which gets used when.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 5, 2015 at 4:42 pm
Welsh Corgi (10/5/2015)
I do not see full backups in the specified Backup folder.It does not make any sense?
What specified folder? Did you do a backup with "backup database" command? We can't see what you see so you're going to have to give us a little something more to go on.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply