Monday, June 25, 2012

SQLServer Error: 15404, Could not obtain information

Date  25/06/2012 08:40:01
Log  SQL Server Agent (Current - 25/06/2012 08:47:00)

Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'servrername\SQLAgent', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin),


If you ever clone sql server from other server. you might end up with this above error when you run any sql server agent jobs. Because name of the current sql server and oringally installed sql server is totally different.

Tuesday, June 19, 2012

Robocopy files to another Drive

Robocopy files to another Drive with estimated time to complete
If you ever plan to move the sql data(mdf) or log file (LDF) to another drive then try to use robocopy is much better than windows file copying and takes less time.

In that command prompt e.g:
F:\Robocopy  "E:\SQLData" "F:\SQLData" mydb.mdf mydb.mdf /ETA

E:\Robocopy  "D:\SQLLogs" "G:\SQLLogs" mydb_log.ldf mydb_log /ETA