Jump to content
Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble
Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble

Forums

  1. Operating System Support

    1. Windows Client OS Support

      For assistance with all Microsoft Windows client operating systems, such as XP, Vista, 7, 8 and the all new Windows 10.

      49,781
      posts
    2. Windows Server Technologies

      Assistance and support can be found in here for all Windows Server, Exchange Server and SharePoint Server.

      532
      posts
    3. Mac, Linux, Chrome OS Support

      If you are looking for help and support or just have a query, and you are not running Windows, this is the place for you.

      2,459
      posts
  2. Support and Discussion

    1. Hardware Support and Discussion

      Problem installing a new piece of hardware, then post in here.

      12,404
      posts
    2. Microsoft Application Support

      For assistance and support with all Microsoft applications such as Office.

      371
      posts
    3. General Software Support and Discussion

      Problem installing an application, can't find a setting, then post in here.

      21,991
      posts
    4. Internet, Networking and Security

      If you are having Internet related problems, network troubles or have a security related question, take a look in here.

      20,266
      posts
    5. Miscellaneous Support!

      Not sure where to post? Post it in here, chances are you'll be right. Use this forum when the others do not apply to the problem that you might be having!

      6,889
      posts
  3. Essentials

    1. Essential Guides

      A catalogue of step by step instructions on various subjects. Submitted by the members, for the members. This forum is also home to 'Essential Guides' created by Powerless.

      1,099
      posts
    2. Essential Reviews

      A catalogue of reviews on various products. Submitted by members, for the members.

      614
      posts
    3. Essential Headlines

      Keep up-to-date with news and information in the computer world.

      9,058
      posts
    4. Essential Software

      Come across some great software? Then tell us about it...

      1,978
      posts
    5. Essential Updates

      Keep up-to-date with new software releases in the computer world.

      950
      posts
  4. Everything Else

    1. The Game Zone

      If you're looking for fun and games, take a look in this board and see what you can find!

      4,458
      posts
    2. Programming, Debugging, Scripting...

      C#, C++, PHP, VB, etc.

      570
      posts
    3. Websites, Design and Code

      Need a helping hand with that HTML? Don't know what the difference is bewteen HTML and XHTML? Still trying to figure out what CSS is all about....then pop in and we'll see what we can do!

      1,507
      posts
    4. Home Cinema, Television, Sky, Virgin Media, Freeview, Freesat

      Don't know your DLP's from your Plasmas? Wondering what a LCD TV is? Are you wanting a 5.1 surround sound setup in your living room? Lets's see what we can do...

      569
      posts
  5. Windows Forum Chat

    1. Windows Forum Related

      Please use this forum to discuss any forum related issues. Windows Forum staff will also use this forum to update you on critical information that affects the forum.

      14,551
      posts
    2. Debates and Poll Station

      Something on your mind? Then debate it, or create a poll and let the voters vote."

      12,751
      posts
    3. Subscribers Lounge

      This is a private lounge for those that have subscribed to Windows Forum. To subscribe to Windows Forum and give your support, please click the subscription link in the top navigation bar or visit your control panel.

      1,248
      posts
    4. 176,854
      posts
    5. NEW Members

      Please introduce yourself here...

       

             

      96
      posts
  • Who's Online   0 Members, 0 Anonymous, 6 Guests (See full list)

    There are no registered users currently online

  • Member Statistics

    21,776
    Total Members
    994
    Most Online
    enmanueljeffren
    Newest Member
    enmanueljeffren
    Joined
  • Today's Birthdays

    1. eltonzoto (42 years old)
  • Latest Threads

  • Current POSTS

    • if I want to use all my peripherals simultaneously on one machine a powered hub is necessary.  
    • It was just my luck to find one card under a removable panel on the underside - but the second card was under the key board. I had to remove the keyboard and all sorts of gubbins to get at it. Everything is so crammed together - I don't think I would try to build one from scratch even if DIY Components were available. I imagine the cost would be prohibitive anyway.
    • The USB drive is an essential part of daily life for carrying data anywhere. The USB drive/SD card is so small that it can carry thousands of photos, music videos in your single small chip. what will you do if your USB flash drive /SD card gets corrupted? continue reading  
    • Enable ACL (Access Control List) with MAC.
    • How to Take backup of All of the Databases available on instance ? Sometimes Its required to take all of the Databases to be backed up periodically for more reliable backup process. If You require to get backup of any critical server's Database then You shouldn't do manually always, It will be better to automate the Process.

      SQL Query to take backup for All the Databases:- 

      DECLARE @name VARCHAR(50) -- database name  
      DECLARE @path VARCHAR(256) -- path for backup files  
      DECLARE @fileName VARCHAR(256) -- filename for backup  
      DECLARE @fileDate VARCHAR(20) -- used for file name

      -- specify database backup directory
      SET @path = 'D:\BKP\'  
        -- specify filename format
      SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) 

      DECLARE db_cursor CURSOR READ_ONLY FOR  
      SELECT name 
      FROM master.dbo.sysdatabases 
      WHERE name NOT IN ('master','model','msdb','tempdb')  -- exclude these databases

      OPEN db_cursor   
      FETCH NEXT FROM db_cursor INTO @name   

      WHILE @@FETCH_STATUS = 0   
      BEGIN   
         SET @fileName = @path + @name + '_' + @fileDate + '.BAK'  
         BACKUP DATABASE @name TO DISK = @fileName  

         FETCH NEXT FROM db_cursor INTO @name   
      END   


      CLOSE db_cursor   
      DEALLOCATE db_cursor
        copy the above query and save it with file name i.e- sqlbackupquery. The above query will give the Database backed up file (.bak) on the location You will set.

      You can run it over SQL server Management Studio (SSMS) or on sqlcmd.

      Query will give you the database backup in the described format below.
      DBName_YYYMMDD.BAK

      You can run it from SQL CMD, with the required parameters. for Example see below.

      sqlcmd -S .\InstanceName -i C:\SQLBackup\SQLBackupQuery.sql (backup query file location and file name)

      If you require it to schedule the Process for backup of all SQL databases on the path where you want You can schedule it from Task Scheduler.

      To create a task go to Run (windows +R) - taskschd.msc and create a task.  schedule it as per the requirement.
       

      Here define the action.
       

      Note- User should have the Admin right,Logon as batch Job Right. You also can automate on SQL Server Express from above query and Process.

      Enjoy, Now You will be able to take the databases backup in one go and schedule it as per your requirement for convenience and saving the time.

      Thanks,
      Sanjeev

      PS- Please write to me or comment if you have any question/Feedback.
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy