Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- AttachDb("sqlDb","[C:Microsoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAsqlDb.mdf] [C:Microsoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAsqlDb_log.ldf]");
- 80131501 Error: An exception occurred while executing a Transact-SQL statement or batch.
- From: Microsoft.SqlServer.ConnectionInfo
- at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
- at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
- at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
- at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
- at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
- 80131500 Error: Attach database failed for Server 'sqlDbServer'.
- From: Microsoft.SqlServer.Smo
- at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
- at TestSMO.AttachDb(String dbname, String filelist)
- static string instance = "";
- static string username = "";
- static string password = "";
- static string connection_timeout = "600";
- static string statement_timeout = "3600";
- //create server connection object
- static Server Connect()
- {
- ServerConnection conn = new ServerConnection();
- instance="sqlDbServer";
- if (instance.Length > 0)
- conn.ServerInstance = instance;
- if (username.Length > 0) {
- conn.LoginSecure = false;
- conn.Login = username;
- conn.Password = password;
- }
- conn.ConnectTimeout = Convert.ToInt32(connection_timeout);
- conn.StatementTimeout = Convert.ToInt32(statement_timeout);
- return new Server(conn);
- }
- //performing attache DB
- static void AttachDb(string dbname, string filelist)
- {
- string[] files = filelist.Split(new char[] {'['}, StringSplitOptions.RemoveEmptyEntries);
- StringCollection dbfiles = new StringCollection();
- foreach (string s in files) {
- string s1 = s.TrimEnd(null);
- s1 = s1.TrimEnd(']');
- if (s1.Length > 0) dbfiles.Add(s1);
- }
- Server svr = Connect();
- string name = DecodeString(dbname);
- svr.AttachDatabase(name, dbfiles);
- }
Add Comment
Please, Sign In to add comment