View Complete Post
I need to connect to 3 remote databases from my local machine and restore 3 .bak files, one for each database.
I am new to asp and sql server and am finding SQL Server Management studio quite confusing. I cannot find any options to connect remotely or restore a database from .bak.
If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.
MSDN Magazine May 2009
Am sorry if this mght be abit silly question am a Novice Developer.
If am using Visual Studio 2008 Pro, Do I need SQL Server Management Studio? or is it included in the VS 2008 Pro Suite? Am learning C# and SQL Server.
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating