Deletion/Rename Of Master Database.
Hi All,
Can we have an sql server installation where we dont have a master database. Can the complete data dictionary be stored in another database , or put it other way can master database be renamed.
I have a need to assume that there will always be a master database for any SQL server instance. Want to confirm whether this assumption is true or not.
Thanks in advance.
Chandrakant Karale.
View Complete Forum Thread with Replies
Related Forum Messages:
Database Deletion
While performing import actions I had a system freeze, when the system returned the sessions had been closed and the database had vanished, with the help of support we recovered the database only to find that the original project ID had a suffix attached ( Original 40/0110, New 40/0110-1 ), when I try to return it to it's original numbering convention it says it has to be a unique number which suggests to me it is not deleted but hiding in the background, can the original be recovered or is it possible to renumber the recovered database, I have searched the whole of the databases and the original is nowhere to be seen.
View Replies !
Database Still 'exists' After Deletion
hi Basically, I create a database with sql, then I delete it manually(not via sql statment. This is a problem which I realise. In fact, you can't delete the database because the VS 2005 still is using it) I run the same code again, then it says the database still exists, even it is physically destroied. ------Here is the errors: System.Data.SqlClient.SqlException: Database 'riskDatabase' already exists. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolea n breakConnection) ------The evidence that the database doesn't exist physically: Unhandled Exception: System.Data.SqlClient.SqlException: Cannot open database "riskDatabase" requested by the login. The login failed. ------The code: /* * C# code to programmically create * database and table. It also inserts * data into the table. */ using System; using System.Collections.Generic; using System.Text; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.IO; namespace riskWizard { public class RiskWizard { // Sql private string connectionString; private SqlConnection connection; private SqlCommand command; // Database private string databaseName; private string currDatabasePath; private string database_mdf; private string database_ldf; public RiskWizard(string databaseName, string currDatabasePath, string database_mdf, string database_ldf) { this.databaseName = databaseName; this.currDatabasePath = currDatabasePath; this.database_mdf = database_mdf; this.database_ldf = database_ldf; } private void executeSql(string sql) { // Create a connection connection = new SqlConnection(connectionString); // Open the connection. if (connection.State == ConnectionState.Open) connection.Close(); connection.ConnectionString = connectionString; connection.Open(); command = new SqlCommand(sql, connection); try { command.ExecuteNonQuery(); } catch (SqlException e) { Console.WriteLine(e.ToString()); } } public void createDatabase() { string database_data = databaseName + "_data"; string database_log = databaseName + "_log"; connectionString = "Data Source=.\SQLExpress;Initial Catalog=;Integrated Security=SSPI;"; string sql = "CREATE DATABASE " + databaseName + " ON PRIMARY" + "(name=" + database_data + ",filename=" + database_mdf + ",size=3," + "maxsize=5,filegrowth=10%)log on" + "(name=" + database_log + ",filename=" + database_ldf + ",size=3," + "maxsize=20,filegrowth=1)"; executeSql(sql); } public void dropDatabase() { connectionString = "Data Source=.\SQLExpress;Initial Catalog=" + databaseName + ";Integrated Security=SSPI;"; string sql = "DROP DATABASE " + databaseName; executeSql(sql); } // Create table. public void createTable(string tableName) { connectionString = "Data Source=.\SQLExpress;Initial Catalog=" + databaseName + ";Integrated Security=SSPI;"; string sql = "CREATE TABLE " + tableName + "(userId INTEGER IDENTITY(1, 1) CONSTRAINT PK_userID PRIMARY KEY," + "name CHAR(50) NOT NULL, address CHAR(255) NOT NULL, employmentTitle TEXT NOT NULL)"; executeSql(sql); } // Insert data public void insertData(string tableName) { string sql; connectionString = "Data Source=.\SQLExpress;Initial Catalog=" + databaseName + ";Integrated Security=SSPI;"; sql = "INSERT INTO " + tableName + "(userId, name, address, employmentTitle) " + "VALUES (1001, 'Puneet Nehra', 'A 449 Sect 19, DELHI', 'project manager') "; executeSql(sql); sql = "INSERT INTO " + tableName + "(userId, name, address, employmentTitle) " + "VALUES (1002, 'Anoop Singh', 'Lodi Road, DELHI', 'software admin') "; executeSql(sql); sql = "INSERT INTO " + tableName + "(userId, name, address, employmentTitle) " + "VALUES (1003, 'Rakesh M', 'Nag Chowk, Jabalpur M.P.', 'tester') "; executeSql(sql); sql = "INSERT INTO " + tableName + "(userId, name, address, employmentTitle) " + "VALUES (1004, 'Madan Kesh', '4th Street, Lane 3, DELHI', 'quality insurance mamager') "; executeSql(sql); } public static void Main(String[] argv) { string databaseName = "riskDatabase"; string currDatabasePath = "E:\liveProgrammes\cSharpWorkplace\riskWizard\A pp_Data"; // Need to be more flexible. string database_mdf = "'E:\liveProgrammes\cSharpWorkplace\riskWizard\ App_Data\riskDatabase.mdf'"; string database_ldf = "'E:\liveProgrammes\cSharpWorkplace\riskWizard\ App_Data\riskDatabase.ldf'"; RiskWizard riskWizard = new RiskWizard(databaseName, currDatabasePath, database_mdf, database_ldf); riskWizard.createDatabase(); riskWizard.createTable("userTable"); riskWizard.insertData("userTable"); //riskWizard.dropDatabase(); } } }
View Replies !
Control If A SQL Database Exists Before Its Creation Or Deletion
Hi, I'm using SQL Server 2005, and I would like to understand how to create and to drop a database without errors: Infact, if I try to create a database that already exists, SQL Server throws the error "Impossible to create the database because it already exists", and if I try to drop a database that doesn't exist, SQL Server throws the error "Impossible to drop the database because it doesn't esist". Before creating or dropping a database, I should control if it exists or not... Is there a method to do that? I found that such control for a table is the following one (in this case, I drop the table only if it exists): if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Table1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Table1] I tried to adapt the statement to the database case, modifying it as follows: if exists (select * from dbo.sysobjects where id = object_id(N'[Database1]') and OBJECTPROPERTY(id, N'IsDatabase') = 1) drop database [Database1] but it didn't function (it was a blind attempt). Can you suggest me a statement to do that? Thank you very much
View Replies !
How To Rename A Database?
hi every time I try to rename my database I face an error I want to rename the database file phisically not just changing logigal name with Alter Database <database name> modify name command please step by step tell me what to do whether with TSql or Managment Studio thanks
View Replies !
How To Rename A Database?
hi I want to rename the phisical file of the dabase for instance rename <MyDatabase.mdf> to <Renameddatabase.mdf> every time I do so whether directly renamin the file or by using Alter Database command I face an error note that I don't want to logically rename the database please tell me step by step what to do thanks in advance
View Replies !
How To Rename A Database?
hi every time I try to rename my database I face an error I want to rename the database file phisically not just changing logigal name with Alter Database <database name> modify name command please step by step tell me what to do whether with using TSql or Managment Studio thanks
View Replies !
Database Rename
Dear experts, is it possible to rename a database? I've tried with harsh suggesion from previous posts.... --alter database Script modify name= script_test Use Master GO Alter database Script Set Single_User GO THANK YOU VERY MUCH Vinod Even you learn 1%, Learn it with 100% confidence.
View Replies !
Rename Database
hi How can i rename database name through command Here i tried with the folloeing statement ALTER DATABASE indraja1 MODIFY NAME = indraja11 but i got error as Msg 5030, Level 16, State 2, Line 1 The database could not be exclusively locked to perform the operation. Thanks in Advance Malathi Rao
View Replies !
Rename A Database Under Mssql 6.5?
Hello: I am supporting a mssql 6.5, sp 4 application. We have set up an user acceptance server with a database that is the same as production. However, I have been told that this database and server may be used for applying fixes rather than user acceptance. To avoid confusion over which database is on which server, it might be a good idea to rename the database. I am not sure if this can be done un der mssql 6.5? 1)Can I rename a database? 2)If so, how can I do so? Which system tables would I use to update? Any information you can furnish will be appreciated. THanks. David Spaisman
View Replies !
Rename A Database During Sp_detach_db?
I was wondering if it is possible to rename a database during the sp_detach_db process? say detach, rename the file, and run sp_attach_db with the new database name. or would it be better to detach, attach to new server, sp_rename_db, detach, attach with new name? the reason i ask is that i have to bring as fresh copy of development up for testing the first of next week. the database is rather large and i am not sure how long a DTS would take. since i have all of this on an emc symetrix box it will take no time for the copies. thanks trea johnson database admin vulcan materials
View Replies !
How To Copy And Rename A Database: Same Server
How does one make a copy of a database (with the data) on the sameserver. Would like to do this to use the copy in a test environment. Ilooked at the Copy Database Wizard but the instructions in Books Onlinestate that the database must be copied to another server and cannot berenamed using this process.Thank you.
View Replies !
SQL VSS Restore With Move And Database Rename
Hello, I tried to use the VSS restore to Rename the database. If I just used setselectedforRestore and then used SetRestoreOptions with "New Component Name" =<"logicalpath/new name">, then the restore always fail at the post restore state. Then I looked at the eventlog. I saw this: Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013 Error state: 1, Severity: 16 Source: Microsoft SQL Native Client Error message: RESTORE DATABASE is terminating abnormally. SQLSTATE: 42000, Native Error: 3119 Error state: 1, Severity: 16 Source: Microsoft SQL Native Client Error message: Problems were identified while planning for the RESTORE statement. Previous messages provide details. SQLSTATE: 42000, Native Error: 3156 Error state: 4, Severity: 16 Source: Microsoft SQL Native Client Error message: File 'pardata_log' cannot be restored to 'G:pardata_log.ldf'. Use WITH MOVE to identify a valid location for the file. SQLSTATE: 42000, Native Error: 1834 Error state: 1, Severity: 16 Source: Microsoft SQL Native Client Error message: The file 'G:pardata_log.ldf' cannot be overwritten. It is being used by database 'pardata'. SQLSTATE: 42000, Native Error: 3156 Error state: 4, Severity: 16 Source: Microsoft SQL Native Client Error message: File 'pardata' cannot be restored to 'F:pardata.mdf'. Use WITH MOVE to identify a valid location for the file. SQLSTATE: 42000, Native Error: 1834 Error state: 1, Severity: 16 Source: Microsoft SQL Native Client Error message: The file 'F:pardata.mdf' cannot be overwritten. It is being used by database 'pardata'. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. So, I think maybe I should implement the Restore with Move whenever I want to using VSS restore to have Database Rename. So is this correct? Please help. I also heard something that u can restore a database to its original location, but with a new name. Is that true?
View Replies !
Configuring Database After Domain Rename
I didn't know exactly which forum to post this in, so if I need to post it into another one, please let me know. Also, I have absolutely no SQL or DB experience. I am learning as I go. The Situation: I created a virtual network for my company which included MS CRM, which uses SQL Server 2005. Everything was working fine until today. My company asked me to make a change to the domain name, as we are changing company names. I followed the processes through microsoft's documentation that I found online. The rename went fine. Since then, we can no longer access CRM. When I run the environment checks, it gets hung up on the SQL Server components. It says that it can't confirm the MSSQLSERVER service is running (it is) and it can't connect to the database. As best as I can tell, the database is looking for the old domain name, which doesn't exist. How do I edit or configure the existing database to reflect the new domain name. It's important to do this as we have data in that database that we need to access. Any help in this matter is very much appreciated!!!
View Replies !
SQL Express: Duplicate, Rename And Copy A Database
Hi, first of all escuse my English. I'm new to SQL Server, my experience is with MySQL, Interbase and Firebird, but now I have a new job so I need to use SQL Server, version 2005 Express. I have two SQL 2005 Express installations in two different machines (local and remote). I can access both servers via SQL Management Studio I need to do the following: 1) Create a copy of a database with a new name in the same machine (local). 2) Copy the new renamed database to another host (remote) Please help me, remember I use Express edition. Thanks in advance. Giorgio
View Replies !
CREATE DATABASE Permission Denied In Database 'master'. Error
got rid of my error about user login rights, it was all working yesterday. but for some reason i now get this error CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734995 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360 i have this in my web.config file <connectionStrings> <add name="ConnectionStringTest" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootsqlSiteApp_DatasiteDB.mdf;Integrated Security=SSPI;Connect Timeout=30;User Instance=False" providerName="System.Data.SqlClient" /> </connectionStrings> <appSettings /> <system.web> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <compilation debug="true" /> <identity impersonate="true"/> and my asp connection string is <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringTest %>" SelectCommand="SELECT [entryID], [compID], [emailAddy], [answer] FROM [entry]"></asp:SqlDataSource> if i set user instance to true i get a user permission error. it says on sql server management that i have dbo rights on my database, but it wont let me put datareader or write on this login. any ideas? its driving me insane
View Replies !
Setting SQL Database So That Cold Fusion Will Go To New Database Instead Of Master
whenenver i run cold fusion, it automatically gets my tables out of the master database instead of the new one i have created. i've added a user that has a default to the new database instead of the master, but i need to know how to use that new user correctly, and what i will need to do once i start adding more databases so that cold fusion will go to the appropriate database and not to the master.
View Replies !
CREATE DATABASE Permission Denied In Database 'master'
Hi, i am creating an VS 2005 deployment package with SQL Server 2005 Express Edition SP2 as a prerequisite. The deployment package executes a CREATE DATABASE statement which generates the in Subject mentioned 262 error. I get the same error if i try to create the database in Management Studio. The computer is running Vista Business. I have read in another tread that this is to be solved with SP2. I have checked the version nr. after installation to 9.0.3042 What can i do about this? Rudolpho
View Replies !
CREATE DATABASE Permission Denied In Database 'master'
Hi, I'm using Visual Studio 2005 Pro and SQLExpress that comes with it. I have my program running fine in XP Pro OS using a window user "Glen" (Computer administrator) with Administrator rights. This means that I installed VS 2005 using this window user "Glen" I created another windows user "TestUser" (Limited account) in the same physical PC. I tried to run the program and on the part that I need to access SQL table, I got the error [CREATE DATABASE permission denied in database 'master'] At the same time while using "TestUser" and running sqlcmd (to check if I can connect to SQL), I also got error HResult 0x2, Level 16, State 1. I read alot on MSDN discussions and related links but it seems that I can't get the solution that I need. SO HERE ARE MY QUESTIONS : 1. Am I allowed to run my program using user "TestUser" since SQL is installed using "Glen" windows user? 2. Do I need to add access rights to "TestUser" to allow the user to have CREATE rights? (Note : for security reason, I can add other access rights except Administrator) Thanks in advance for all you help.
View Replies !
Master Database
Hi Y'all, What are the advantages of placing stored procedures in the master database? Can i always use all the database-names on the instance? Thanks!
View Replies !
Everyone Can See The Master Database?
I installed SQL Server, created a database for a sql server user andnoticed that the user has access to the master database even though thecheckbox for master database for the user login is not checked.They can list sysusers and find out all the names. They can list all thedatabases as well by using sp_helpdb.Is this normal behavior?If I check db_denydatareader and db_denydatawriter in the master databasefor that user, will that break anything?John Dalberg
View Replies !
DTS On Master Database
I tried to import a stored procedure from one Master database to another Master database, but it won't allow me. I then tried to copy and paste that system stored procedure on isql, but it still won't allow me. Why I can do a DTS on other databases, except on Master database? Is there any way around it? Thanks for any help.
View Replies !
Master Database
hi, What are the symptoms that the master database is currepted? If I do not know the databases sort order, code page, and Unicode collation and I had a master database crash, it is important during the rebuild process to maintain same configuration, Is there a way to run a script which tells me the configuration set up of the master database. so I know ahead of time what configurations Ican use during the rebuilding process. Ahmed
View Replies !
Master Database
Hi, I have a question regarding master database.I know if a master database is corrupt we need to rebuild the master.One of the guys suggested us to maintain a copy of master data file and log file in diffrent directory and when master database is corrupt we can copy the files to the actual location and restart the sql server and this should fix the issue and by this method we can save the time of rebuilding the master database.I don't know if this works.Can anyone please tell me if this works and also disadvantages if any with this method? thanks Mohan
View Replies !
Master Database Changes
Various books read suggest that the Master database be backed up when it is changed.' What activities does a DBA perform (or perhaps) a user) will cause the Master database to change? I am aware that information about the addition of new databases is kept in the Master. TIA Gary
View Replies !
Database Master Key
Hi For encytion in database, the following statement is correct? I found it in msdn book. The database master key is not mandatory if you want to encrypt data.
View Replies !
Restore Master Database
ALL, When I attempt to restore a master database I am having some issues. I am using SQL Server 2000. I have set the start up option with -c -m to set the database in single user mode. When I run the restore from enterprise manager I am get an popup window that is titled "SQL-DMo(odbc SQLSTATE:HY000)" with not message and then the database conection is lost. Thus the master datbase is appears to it was not resotred. As when I close enterprise manager and then restart the MSSQLSERVER service the database is in the same state. Please advise on how i can get the Database restored. Thanks Chris
View Replies !
Restore Master Database
Hello All, I am going through the procedure of restoring the master database as described in the Microsoft SQL 6.5 Survival Guide by SAMS. I deleted the master.dat file from c:mssqldatamaster.dat. I went into setup and choose rebuild master database. After rebuilding the master database, I went into setup again to add the "-m" server option to start server in single user mode so I can load the master database from backup. Then I went into Enterprise Manager to start the server. The server started, but when I try to double click on the server. It gave me the following " A connection could not be established to [server name] - SQL server login failed." I try reregistering the server, but gave me the same error. The SQL server is using standard security. Does anybody know what I did wrong? Pauli
View Replies !
Restore Master Database
I would like to restore the master database from a current backup tape but I got the error “Load database must be used in single user mode if trying to restore the Master database”. I tried to change the master database option but the option ‘single user’ cannot be changed for the ‘master’ database. Then I tried to start the SQL Server in Single-User Mode but I was not able to restore the master database from a tape. Would anybody help me on how to restore the Master database like any other database? Many thanks Stella Liu
View Replies !
Loss Master Database
After rebuilding my SQL 6.5 server and restoring all of my drives I noticed that the mssql/data direcory didnt properly backup. I reinstalled SQL, applied SP5a, recreated my device and databases, and then replaced my dat files from my restores. The only database that I am affraid of is my Master. I can run Queries successfully against all my databases successfully. Is there anything else I need to do or should be worried about? I might be able to restore the master from a backup done earlier yesterday morning. But dont want to unless necessary. Thanks in advance. David
View Replies !
Recoverring The Master Database (DRP)
Folks: I've recently been tasked with creating a plan for disaster recovery of our environment. (mixed SQL 6.5 and SQL 7.0). For the SQL 6.5 process, the documented (first step) is to run setup and choose the recover master button. The problem that I am running into, is 'sometimes' setup fails, and looking at the sql error logs, I see that the max users is exceeded and therefor setup cannot continue... The only user I see logging in is 'PROBE' - and it fails 5 times, which I assume is what is eating up the 5 user limit (I guess setup runs in minimal mode) Is there something I need to do, to prevent PROBE from attempting to login? or someway to increase the user limit when in minimal mode? Thanks in advance for any thoughts on this problem!
View Replies !
Transfer Of Master Database In SQL 6.5
We are currently in the process of transferring a database from one server (sql 6.5) to another (SQL 6.5) but in order to successfully transfer the database we have to transfer the master database first. Any ideas on how to transfer the Master database successfully ???
View Replies !
Master Database Too Large
Greetings, Looking for some hints and advice on resizing master database. I have recently taken over a SQL server where someone has set the size of the master database way too large 2GB, does anyone know of a way to resize the database device without dropping it and or can you drop the master database? The size of the database is causing disk space problems and must be rectifyed. Any suggestions would be appriciated. Cheers ...
View Replies !
Moving The MASTER Database
We're changing our server. Both servers are SQL 2000. If I backup the MASTER on the first box and restore it on the second box (considering all the databases and... are alike) what could go wrong? Any other suggestion?
View Replies !
RESTORE Master Database
Hallo I do my backup using BACKUP database <myDB> TO DISK='D:BACKUPmyDB.bak' I do this for ALL my databases every day. Another product writes every day all the files on the server to tape EXCEPT the online databases because these files are open by SQL server 2000. Now I restore the files of the tape to the server This works well but I haven't got the online databases !! And because the master database isn't available, SQL server wont start ... BUT I have the backup of the master database 'D:BACKUPMaster_data.bak' How can I use this master backup to do a restore even when SQL server can't start ? Or must I do the bakup of the master database in another way ?
View Replies !
Synch With Master Database
Hi all, We are going to have several dozen servers around the country- each with a mirror copy of the initial database (blank) loaded upon them. The data will be entered at each station, and then once a month, the systems will dial into the 'net and - this is where i am getting stuck - we would like the data from the remote areas to update the data in the master database - What would be the best solution to update the data from the remote station into the master database??? thanks tony
View Replies !
Restoring A Master Database
Iam planning to move the production server from one server to another. Can any one tell me how to do the migration of the master,model and msdb database. Help in this regard is highly appreciated.Is it ok if I do the dts for these three databases Thanks Naveen.
View Replies !
Restoring Master Database
In SQL 7 Books Online, the suggested method for disaster recovery is to restore the master database along with msdb and user databases. I am testing this and have an issue restoring the master database. I start SQL in single user mode connected as sa. Using Enterprise Manager to initiate the restore I get the following error: Microsoft SQL-DMO (ODBC SQLState:01000) ConnectionTransact (GetOverlappedResult()) Connection broken. This stops SQL Server, and prevents subsequent connections and the only fix is to rebuild the master database. Any ideas? Although user databases can be recreated and restored without restoring the original master, configuration, security and user logon information is lost without it. Thanks.
View Replies !
|
TRACKER
