Author |
Topic |
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2010-01-25 : 06:07:03
|
Hi Everyone,I can take back of the database that is available on my PC. But problem is that, there is a database that is deploy on onother server. I have not remote access of this PC. But i have remote access of the Ms SSMS. I can view, modify , create scripts. Now I need to take backup of this db. Will any one let me know, how can I do this.thanx in Advance.FeejazNavi |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 06:39:20
|
you can take backup from ssms also. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 06:44:41
|
also seehttp://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups |
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2010-01-25 : 06:56:44
|
Thanx for Replying, As I told earlier, I have deployed the database on the server. And I have not remote access of this Computer (pc). But I have access of remote Ms SSMS. How can I get the backup of this database on my local pc.Navi |
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2010-01-25 : 07:03:19
|
Now, Aagain I have described my problem in detail.I have SqlServer 2005 Standard EditionInstalled on the local pc. A Database is deployed on the hosting company's machine and have Sql Server 2005 Express editionI have a website and an MSSQL database which is hosted with a hosting company, I am using microsoft sql studio express to connect to a database, but I am unable to do the backups of the databse as I do not have the permission to access the drives on the remote server and mssql studio STANDARD does not have the option to back up the database from remote server to my local pc. So is there any software available from microsoft or 3rd party software which would enable me to backup my database and if would have a scheduling option it would be even better so i can schedule it to do daily backups.Navi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 07:06:50
|
you can give unc path in place where you give backup location provided it satisfies belowhttp://support.microsoft.com/kb/555128 |
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2010-01-25 : 07:27:17
|
Thanxs for replying again.I have not access of the network folders/share folders. As database deploying on the hosting server. Can I still get the database on my local drives?Navi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-25 : 07:59:51
|
yup. just created a folder in your pc shared to network and give permissions for account connecting to sql then you should be able to do it |
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2010-01-25 : 08:10:05
|
I could not understand "just created a folder in your pc shared to network". Would you please describe it in more detail.Navi |
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2010-01-25 : 08:22:44
|
I created a folder on my local machine. How can I add the remote Sql user with folder.like below are the credientials1- Remote Server name = xyz.com2- Username = test3- Passwor= 123Navi |
|
|
feejaz
Yak Posting Veteran
68 Posts |
|
|