April 10, 2008 at 2:40 am
Is it possible to restore a database backup via the TCP/IP connection?
If someone has an experience with that please inform me
April 10, 2008 at 2:54 am
What do you mean via TCP/IP connection?
If you're connected to a SQL Server (doesn't matter how) and you've got sufficient permissions and you're able to issue commands then you can restore a database by issuing a restore database command.
April 10, 2008 at 2:58 am
I have to install my application which is using the SQL Server database, I don't have any rights on the server, so I can connect only via TCP/IP
April 10, 2008 at 3:06 am
bmanu98 (4/10/2008)
I have to install my application which is using the SQL Server database, I don't have any rights on the server, so I can connect only via TCP/IP
Like I said, if you are able to connect to the SQL Server and you have sufficient permissions to issue a restore database command you can do this.
I'd suggest you talk to your DBA though before you go about restoring a database.
April 10, 2008 at 6:06 am
Our entire enterprise is running on TCP/IP connections (I suspect most are these days). If you can connect to your SQL Server instance and run 'SELECT * FROM SomeTable', then you can connect to the same instance and run 'RESTORE DATABASE X FROM DISK = C:\mybackup.bak'. That assumes you have the appropriate permissions on the server of course.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply