Alok, Normally the back up size will be your DB size (40 GB in this case). if you use SQL litespeed, it can shirnk back up up to 4~5 GB. --jacks. ... From:...
Alok, Backup size depands on actual data in database. Backup does not contents free space so check all this and try to identify the backup size. Due to this...
Hi Alok, If you have space requirements, you can use third party backup tools. Idera is giving a free backup tool with limited functionality. If you are...
Hi Nitin, You can use a SSIS package to do this task. If you are using SQL Server 2005 Enterprise Edition you can archive int the same database (but to a...
hello, I have to perform a task between two server first server is sql server 2000 with win server 2000 , there is a user data base named delta with 150 tables...
Hi friends, In SSIS Package i have to use inner join for two table, iam using Merge join but in merge join output some records are missing, how we can achieve...
From the given scenario, i think you have couple of options. You can either go for Log Shipping or Replication(Probably Transactional). In 2005 you have...
Thanks Madhu, for the guidance but i have some point, 1)-can log shipping may be planed for only one data base and is it appropriate. 2)- suppose i plan for...
Alok, Here is your answers. 1 - You can create Log Shpping for all databases but one setup for one database means you have to setup Log Shipping one by one for...
thanks i got your point,but if i want database live on second server all the time, but with log shipping it will be standby mode and can only be use when...
You can do this task by replication (transactional). You can keep both the databases always in synchronization. 8000 records will be there on 2nd server. ...
... Merge join but in merge join output some records are missing, how we can achieve this problem, i don't want to use import export wizard or execute sql...
Alok, You can use Log-shipping and Transactional replication for this purpose. Check your requirement and let me know how will you use secondry server. If you...
Alok, In Log-shipping you have 2 option: 1. All time inaccessible (You can not access database but you can bring ur database up when needed and then you can...
HI Alok So while again performing replication, there will be 8000 records. What ever transaction is done, its replicated, wether its addition,update or...
So for I think Replication would be one of the best option for getting reflection of changes in primary database. ... -- Thanks & Regards Shashi Kumar Singh ...
Hi All, I need to create a Job on Sql Server 2000 which will monitor my replication(Transactional). If my replication failed/stopped and this job will ran, i...
Manish, It's simple. Internally SQL generates job for you. You need to get the data from MSDB --> Sysjobs, sysjobsteps and Sysjobhistory and sysschedle....
Hello, We have set up some jobs that run at a frequency of 5mins. These jobs finish in the scheduled time, but sometimes they take a longer time to complete....
Hi, Is there any Mechanism wherein i can store the information of Which user has accessed the Database, Start Time and End Time of that session Queries...
Manish, You can monitor all your replication jobs thru this script... if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CHK_Failed_Job]')...
Sandeep, Thanks for the Reply Can i Use SQL Server CLR to do this or do i need to do some .Net programming using Visual Studio to parse the Trace file and get...
Hi Vinay, Here can I ask what is CLR and what exactly it will do. Best Regards, Krishna Vinay C Reddy <vinaycreddy@...> wrote: Sandeep, Thanks for the...
Krishna, CLR .... Common Language Runtime , a new feature in SQL Server 2005. ... -- Regards Vinay C Reddy [Non-text portions of this message have been...
5989
sqlcon@yahoogroups.com
Feb 15, 2008 2:14 pm
The following sqlcon poll is now closed. Here are the final results: POLL QUESTION: Quiz! What is the quickest way to copy a table from one database to...