JinxT
Last Activity: Apr 22 '10, 01:17 PM
Joined: Apr 9 '08
Location:
-
Thanks Tonk, including the '-o' in the "" solved it for me! -
Hi,
You could use an ssis package with a copy database task. Or you could write a stored procedure in which you backup from server A, then restore to server B via a linked server - then schedule stored procedure in SQL Agent.
Jinx....Leave a comment:
-
Problem with 7zip unzip using exec master..xp_cmdshell
Hi,
I am trying to implement custom log shipping but only have Standard Edition to am unable to use compressed backups..so have resorted to a customised version. As our transaction log files can reach several gb I need them zipped.
I have managed to zip a file using xp_cmdshell as follows:
...Code:exec master..xp_cmdshell 'C:\Progra~1\7-Zip\7z.exe a -t7z "D:\Microsoft SQL Server\MSSQL\Backup\archive_data.7z"
-
Hi,
Take a look at this link :
http://www.sqlserverce ntral.com/Forums/Topic550007-5-1.aspx
J.Leave a comment:
-
Try this:
CREATE PROCEDURE [dbo].[sp_send_cdosysm ail]
@From varchar(100) ,
@To varchar(100) ,
@Subject varchar(100)=" ",
@Body varchar(4000) =" ",
@server varchar(25) = 'YourServer'
AS
Declare @iMsg int
Declare @hr int
Declare @source varchar(255)
Declare @description varchar(500)
Declare...Leave a comment:
-
Hi,
You need to deny permissions on the tables but allow select permission on the view. I tested this using SQL Express then using odbc and excel to test access - and it worked fine. The user logged in and could not see the tables but could see the view. The user was not a member of any group that may have select permission on the tables.
As far as I have always understood it- much of the purpose of a view is for this exact...Leave a comment:
-
Hi,
If the data is not critical, consider changing to Simple Recovery Mode, if it is critical then you need to stay in Full recovery but implement frequent log backups.
ALTER DATABASE mydb SET RECOVERY FULL/SIMPLE
GO
here is a useful site: http://www.akadia.com/services/sqlsrv_programm ing.html...Leave a comment:
-
Hi,
Thanks for the solution, it worked perfectly! :-)Leave a comment:
-
Stored Proc not working in DTS
Hi,
I am trying to execute a stored procedure within a DTS. The sp works fine from query analyser and inserts all rows as it should, but when exec in DTS the insert does not occur and the table remains empty.
The stored procedure is as follows:
CREATE PROCEDURE dbo.sp_load_pr_ monthly
AS
declare @dater datetime
set @dater = dbo.usf_BeginMo nth(getdate());
insert...
No activity results to display
Leave a comment: