I want to have the complete backup of MSSQL db implemented in MSSQL 2008, but...
Posted on 2011-02-26
I am using MSSQL Management Studio.
I want to have the complete backup of MSSQL db implemented in MSSQL 2008, and yes I can have the backup file, but the issue is:
I can connect the local server of mine whereas in the other machine that I want to use that backup, I cannot since I fail to connect to server, I am using windows auth. in the server (and can connect successfully in that one).
So, my aim is that I want not only transfer the complete backup of db but also complete settings of the server (that is operating successfully).
I also tried to find mdf or ldf (which I am not sure their relevancy), and even cannot find the files (in the server operating normally). Where are they?