SQL doesn't see .bak file?

Question

SQL doesn't see .bak file?

Viewing 3 posts - 16 through 17 (of 17 total)

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

msspurlock SSC Journeyman Points: 78 More actions · Answer 1

The dumbness isn't in the question, but in Microsoft's permissions design.

satnam.singh 44358 Ten Centuries Points: 1300 More actions · Answer 2

Sometimes it happens that when you select a particular Backup File to Restore, you need to Select File Type as All Files in the Drop Down. I hope that works well.

With Thanks,

Satnam

MMartin1 One Orange Chip Points: 27779 More actions · Answer 3

Under SSMS> Server Objects, >

there is a Backup Devices folder. Here you can easily create a .bak file and easily find it later as well through here. You can point the backup device to another directory if you wish.

Initially this just creates a pointer. Then when you actually do a backup you point to this device instead of using the file system. Always test restores as well, just something to remember.

----------------------------------------------------