Start SQL with /f /mSQLCMD Connect to SQL via SQLCMD. Run following ALTER command1> ALTER DATABASE tempdb MODIFY FILE2> (NAME = ‘tempdev’, FILENAME = ‘E:\TempDB\TempDB.mdf’)3> GO 1>Exit net stop MSSQLSERVERnet start MSSQLSERVER By: P Dave
There are a few reasons that this task may fail, but one of the most common is the follow: In Maintenance Cleanup Tasks, check to make certain the file extension entered is bak and not .bak. Save your change and then test it. It is normal to put a “.” then the file type in
We were recently faced with getting into a Sybase database where we had fully authorized Administrator access to the NT system, but everybody who knew the “sa” password was long gone. We positively needed the data, so we found a way in, and we’re recording this here so we don’t forget how we did this.
To resolve this error do the following: mysql_upgrade -u root -p
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES) 1.stop mysql service with “service mysqld stop” 2.start mysql service with “/usr/local/mysql/bin/mysqld_safe –skip-grant-tables & ” 3.Login mysql with “mysql -u root -p” 4.These are finished in mysql command line: USE mysql; UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’; FLUSH PRIVILEGES; quit 5.restart mysql service with