0
I am starting the construction of a web application using SQL Server and talked to my client to provide the backup of the database avoiding access to its production base, because it has no homologation base. It was generated the . 10GB Bak where your uncompressed base comes close to 50GB and I don’t have enough space on my machine as I have an SSD with only 250GB.
My doubt, the possibility of running this database directly from an External HD, because only I will develop application?
I’m ruling out the possibility of generating the script with the database structure, because I need the data to build the application.
Thank you and thank you in advance.
Did you try to use DB on external hard drive? did not work, gave some error or something like?
– Bacco
Because Voce needs the data?
– Intruso
Tests with customer data list, for reports, grids, pagination etc
– Bruno Leite
@Bacco did not try because I am without External HD. I searched the net and could not find something in the same situation.
– Bruno Leite
In principle, if it is a HD connected by USB, it will be slower than access to a HD connected directly on the machine, but in theory the physical connection is not to make any more difference in the access to data besides.
– Bacco
@Bacco yes. HD Connected by USB 3.0.
– Bruno Leite
@Brunoleite, I suggest that, for development, work with sample data and not with the entire database.
– José Diz
Works normally, already tested... The external hard drive needs to be formatted in NTFS, vc can even do the installation of SQL Server in the hard drive (not recommend it is too slow).
– André Negrelli