Can SQL Server Express LocalDB be connected to remotely?

by

No, SQL Server Express LocalDB doesn’t accept remote connections.

The idea with shared network folder might work, but only if you are able to make sure the LocalDB instance is shutdown before you try to copy the file. Also keep in mind that only one LocalDB instance can have any given database file open at the same time. and don’t forget about the log files!

Additional security warning: unlike SQL Server Compact databases, SQL Server Express databases (including LocalDB ones) are not designed as secure data exchange format. For instance, they can contain malicious code in .NET assemblies embedded in them. So you should never open databases from untrusted source.

Maybe providing the customer with a simple tool that automates the backup process would be a better idea?

More Related Contents:

  1. How can I do a BEFORE UPDATED trigger with sql server?
  2. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  3. Is it possible to use greater than equal to operator in group by? [closed]
  4. Identity increment is jumping in SQL Server database
  5. Solutions for INSERT OR UPDATE on SQL Server
  6. How can I schedule a job to run a SQL query daily?
  7. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  8. Reset identity seed after deleting records in SQL Server
  9. Querying data by joining two tables in two database on different servers
  10. Generate a resultset of incrementing dates in TSQL
  11. What is best tool to compare two SQL Server databases (schema and data)? [duplicate]
  12. How Can I use “Date” Datatype in sql server?
  13. How to replace a string in a SQL Server Table Column
  14. What is the difference between using a cross join and putting a comma between the two tables?
  15. Pivot Table and Concatenate Columns
  16. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  17. How to run a stored procedure in sql server every hour?
  18. Sequence vs identity
  19. Composite Primary key vs additional “ID” column?
  20. Why do you create a View in a database?
  21. Logging ALL Queries on a SQL Server 2008 Express Database?
  22. How to run a stored procedure every day in SQL Server Express Edition?
  23. The backend version is not supported to design database diagrams or tables
  24. Find min and max for subsets of consecutive rows – gaps and islands
  25. How do I list all the columns in a table?
  26. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  27. Cannot Resolve Collation Conflict
  28. Try_Convert for SQL Server 2008 R2
  29. How to get Previous Value for Null Values
  30. Can’t create stored procedure with table output parameter

Leave a Comment