Tech for the Enterprise

March 23, 2010

Backing up MS SQL Database with no access to the Phisical Console or RDP to the Server.

Filed under: Backup — Rick @ 8:50 pm

Before you do anything you have to create a dumpdevice. Once that is created I was able to backup no problem. This was done with Owner Rights to this Database in MS SQL 2005.

EXEC sp_addumpdevice ‘disk’, ‘anynameyouwant’, ‘E:\backup\databasename.bak’
BACKUP database databasename TO anynameyouwant
GO

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress