Once the database is attached, a new log file will be automatically generated based on the physical path. An error will be generated if a log file exists in the same directory as the data file and the 'database' keyword is used when attaching the primary data file. The database name must be specified with the keyword 'database' (or one of its aliases) as in the following: "AttachDbFileName=|DataDirectory|\data\YourDB.mdf integrated security=true database=YourDatabase". Note that remote servers, HTTP, and UNC (\\server\sharename\folder\) path names are not supported. If DataDirectory is used, the database file must exist within a subdirectory of the directory pointed to by the substitution string. The path may be absolute or relative by using the DataDirectory substitution string. The attachment will fail if the primary data file is read-only. AttachDBFilename is only supported for primary data files with an. ![]() The name of the primary database file, including the full path name of an attachable database. Recognized values are true, false, yes, and no. When true, enables asynchronous operation support. The name of the application, or '.Net SqlClient Data Provider' if no applicationname is provided.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |