User Profile

Collapse

Profile Sidebar

Collapse
lbseong
lbseong
Last Activity: Nov 19 '08, 02:53 AM
Joined: Sep 11 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • lbseong
    started a topic SQL2000:Moving whole server(10 Dbs+100 login+100+Jobs) into Brand New Server
    in SQL Server

    SQL2000:Moving whole server(10 Dbs+100 login+100+Jobs) into Brand New Server

    Hi Expert,
    I am currently looking for the way for the migration.We have purchase new server and need to migrate all the entire database, sql jobs, sql login into this brand new server. I would like to get some advice on the above mention.
    In fact I have come out some plan where I was thinkig:-
    1.) Restore MSDB
    2.) Restore Master?? (not success)
    3.) Backup all dbs and restore with read only
    4.) Log shipp...
    See more | Go to post
    • lbseong
      replied to SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)
      in SQL Server
      Hello,
      Thanks for your advise, can I just check with u, my database is for internet access and not allow to be down, I guess maybe the dbccindexdefrag will help a little bit, dbcc reindex will not allow as the db is 24 hours accessible...do you have any other good suggestion? maybe like shinking individual table command...fyi, the shrinking for 3 -5 mb have taken like 1 hour + and not completed...ai. .....
      See more | Go to post

        Leave a comment:

      • lbseong
        replied to SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)
        in SQL Server
        Thanks to you guy for giving me help ...

        This is the result base on (select cast(size/128.0 as decimal(10,1)) as [size mb], cast(FILEPROPER TY(f.name, 'spaceused')/128.0 as decimal(10,1)) as [used mb], maxsize [maxsize mb]
        , cast(growth*8/1024 as varchar(11))+ca se when f.status&0x1000 00>0 then '%' else '' end [growth]
        , isnull(filegrou p_name(f.groupi d),'log') [groupname]
        , cast(100*(size/128-(FILEPROPERTY(f .name,'spaceuse d')/128))/(size/128.0)        ...
        See more | Go to post

          Leave a comment:

        • lbseong
          started a topic SQL2K +SP3 Replication error
          in SQL Server

          SQL2K +SP3 Replication error

          Hi expect...
          I have ancounter another difficulty..I am getting an error message for replication
          "error 14294: supply either @job_id or @job_name to identify the job"
          This happen, after I have create a Success replication, then I delete and re-create back the job..then I have encounter this error message and not allow me to create the replicaiton job.
          I have done some test in my local machine, with SQL2K+SP4,...
          See more | Go to post
          • lbseong
            started a topic SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)
            in SQL Server

            SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)

            Good day,
            I felt this forum is good because the reply is fast and relevent. so, this is my second question...
            I am working on SQL2000, one of my db is use up around 250gb, and the hard disk is running out of space soon...(very soon).
            I have run the sp_spacesused and found that the unallocate db is

            database_name database_size unallocated space ---- ...
            See more | Go to post
            • lbseong
              replied to SQL2000- How to use DateDiff Function together with (If then..else)
              in SQL Server
              this is cool...is working. thanks
              See more | Go to post

                Leave a comment:

              • lbseong
                started a topic SQL2000- How to use DateDiff Function together with (If then..else)
                in SQL Server

                SQL2000- How to use DateDiff Function together with (If then..else)

                Hi, I am new to this forum please help.

                I need to schedule a job to send out an email if found there is a records older than 1 minute (compare to current date time against createddate) and the email will contain the itemid.

                mytable design
                1.) itemid int
                createddate getdatetime()
                summaryid varchar
                startdate datetime
                enddate datetime

                ...
                See more | Go to post
                No activity results to display
                Show More
                Working...