Viewing 15 posts - 316 through 330 (of 1,166 total)
If you have the space on destination server... then first restore a db copy as different name from Laptop...
Once the db is present on destination server you can use SSIS,...
February 11, 2007 at 3:34 am
Based on the error it looks like some authentication issue...
Upgrade advisor will check for procedures,logins and dts etc...
February 11, 2007 at 3:20 am
Distributor agent jobs may be stopped ...
If you want continuous replication by default sql add the schedule to run when agent starts... you can add another schedule to run every...
February 9, 2007 at 5:52 pm
It depends on the server HW and memory..
Also Statitics...
February 9, 2007 at 5:46 pm
I don't think it is possible to change the features...
February 9, 2007 at 5:43 pm
It can be done using SSIS
OR
SQLcmd with BCP...
February 9, 2007 at 5:41 pm
No clue what cuased it...
But what service pack you were on?
Did you run the Upgrade adviser before upgrade?
February 9, 2007 at 5:38 pm
You can create a job and script it..
Any way here is the script...
USE [msdb]
GO
/****** Object: Job [test] Script Date: 02/09/2007 16:28:39 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object: JobCategory...
February 9, 2007 at 5:29 pm
Vertical partitioning is supported by MS...
I don't think you can use the query in while creating the publication but once the publication is created...
Right click publication/properties/click on "Filter Columns" tab...
February 9, 2007 at 5:24 pm
I think it doable but I don't have any docs...
You may to install SQL 2000 before installing 2005...
February 9, 2007 at 4:59 pm
Modify the following script as needed...
select step_name,'run_date'= cast(h.run_date as varchar(8)),
'run_time'= replicate('0',6-len(h.run_time))+cast(h.run_time as varchar(6)),
'run_datetime' = left(cast(h.run_date as varchar(8)),4)+'/'
+substring(cast(h.run_date as varchar(8)),5,2)+'/'
+right(cast(h.run_date as varchar(8)),2)+' '
+left(replicate('0',6-len(h.run_time))+cast(h.run_time as varchar(6)),2)+':'
+substring(replicate('0',6-len(h.run_time))+cast(h.run_time as varchar(6)),3,2)+':'
+right(replicate('0',6-len(h.run_time))+cast(h.run_time as varchar(6)),2),
--run_duration = cast(h.run_duration...
February 9, 2007 at 4:35 pm
My personal openion it is not go to run inplace upgrade...some times if you get the errors like this...there will not be any option to go back..
Better to side by...
February 9, 2007 at 4:33 pm
It depends how your snapshot is configured...
What properties missing?
February 8, 2007 at 6:09 pm
You can't remove appended backup files from a backup files.
I think you creating one backup file for each day...
Is there any reason appending the backup to single file?
February 8, 2007 at 6:08 pm
Viewing 15 posts - 316 through 330 (of 1,166 total)