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

Installing sql studio express Error 29506

Filed under: SQL Server,Software — Rick @ 8:33 pm

I tried to install SQL Studio Express and got and error Error 29506. Windows 7 – 64 Bit but I do not think that was the issue. I right clicked on the command prompt and clicked run as Administrator and then ran the msi and it ran with no error.

Powered by WordPress