forked from SQLServerIO/MSSQL-Compressed-Backup
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtodo.txt
More file actions
68 lines (61 loc) · 3.54 KB
/
todo.txt
File metadata and controls
68 lines (61 loc) · 3.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
document:
only works on the same machine as SQL Server.
document using SQL authenticated accounts.
backup strategies with full log and diffs.
which compression should I use?
How do they compare?
roadmap:
gui
add command line option to check to see if file exists with overwrite or not.
when overwriting a file, don't destroy/recreate, but overwrite in place to preserve a defraged file.
set inital file size based on backup size estimate then trim back down to actuall file size prevents file fragmentation.
Build an installer.
CLR stored procedure helpers.
Multiplex file streams to a single file.
Suggested Plugins
Database plugins:
Pipeline plugins:
7z plugin
Encryption Pipeline plugins:
Blowfish
3DES
Resource Governor plugins:
cpu
Storage plugins:
ftp plugin
sftp plugin
done:
striped backups
Needs a completion message with stats: MB/s, MB read, MB written, compression ratio, etc
Rijendel encryption plugin
LZ4 plugin
zip plugin
restore header only
restore file list only
restore verify only
regressions:
make it SQL 2000 compatible.
Current query to pull header and file detail only works with 2005 and above
BUG: This can cause a failure with slow compressors if the elapsedTime.TotalSeconds is set too low C:\Source\MSSQLCompressedBackup\MSBackupPipe.Cmd\CommandLineNotifier.cs 175
BUG: apparently there is a possibility that we will get a zero length string back C:\Source\MSSQLCompressedBackup\MSBackupPipe.Cmd\CommandLineNotifier.cs 155
TODO: Verify SQL Server version compatibility preferred 2000 throught 2014+
TODO: restore on top of an existing database? no error message
TODO: package version number does not match assembly's version number.
TODO: error on overwrite?
TODO: Do escaped cmd line args work?
TODO: check file extensions
TODO: cntl-c kills the app, but we can handle the event.
TODO: better device timeout, longer execution timeout (db might be locked)
TODO: force kill all active connections on restore.
TODO: tie this to STATS instead of a time frame. C:\Source\MSSQLCompressedBackup\MSBackupPipe.Cmd\CommandLineNotifier.cs 176
TODO: Switch to turn off tracking stream C:\Source\MSSQLCompressedBackup\MSBackupPipe.StdPlugins\TrackingStream.cs 26
TODO: simplify checker C:\Source\MSSQLCompressedBackup\MSBackupPipe.Common\SqlThread.cs 455
TODO: preallocate file to speed up writes and cut down on fragmentations C:\Source\MSSQLCompressedBackup\MSBackupPipe.StdPlugins\Storage\LocalStorage.cs 89
TODO: enable switch to turn stats reporting on or off C:\Source\MSSQLCompressedBackup\MSBackupPipe.StdPlugins\Database\DatabaseSource.cs 63
TODO: cut down on verbosity of error messages in release mode C:\Source\MSSQLCompressedBackup\MSBackupPipe.Cmd\Program.cs 444
TODO: currently shows time remaining need to add a switch to show ether time remaining or estimated datetime to finish. C:\Source\MSSQLCompressedBackup\MSBackupPipe.Cmd\CommandLineNotifier.cs 83
TODO: add validator for STATS other than is number C:\Source\MSSQLCompressedBackup\MSBackupPipe.StdPlugins\Database\DatabaseSource.cs 257
TODO: add validator for maxtransfersize other than is number C:\Source\MSSQLCompressedBackup\MSBackupPipe.StdPlugins\Database\DatabaseSource.cs 224
TODO: add validator for blocksize other than is number C:\Source\MSSQLCompressedBackup\MSBackupPipe.StdPlugins\Database\DatabaseSource.cs 240
TODO: add unbuffered IO to speed up writes and cut down on memory usage C:\Source\MSSQLCompressedBackup\MSBackupPipe.StdPlugins\Storage\LocalStorage.cs 90
TODO: add pause on complete switch to command line C:\Source\MSSQLCompressedBackup\MSBackupPipe.Cmd\Program.cs 52