Question about Microsoft SQL Server Standard Edition for PC

1 Answer

Need solution............. how to automate the backup of a sql server2005?i need clear solution immediately pls.......

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer
Re: Need solution............. - Microsoft SQL Server Standard Edition for PC Business & Productivity Software

Compiler require

Posted on Oct 17, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

Creating a new database using an MDF file

An MDF file isn't a backup file isn't the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks and then Attach Database.
When you do this you will get an error about the log file missing. This shouldn't matter as SQL Server will simply create a new log file for you.
This will only work if the SQL Server was stopped when you copied the MDF file from the old SQL Server. If you copied the file while the SQL Server was running this file probably will not attach either and you will need to get a valid backup of the database.
Download help tool for sql database - SQL Server Restore Toolbox.
You can read up more on SQL Server here.

Nov 16, 2014 | Microsoft SQL Server 2000 Standard Edition...

3 Answers

Is it good idea to repair sql file?

Bulk Logged will not help you in this situation. Your transaction log is growing because you are performing large transactions. In simple mode, the log is truncated after a checkpoint.
Check these site: & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.
Read more:

Nov 06, 2014 | Microsoft SQL Server 2005 Standard Edition

5 Answers

How to recover deleted Microsoft SQL server MDF files?

Recover and repair MDF files with simple and efficetive tool to repair and recover MDF files from corrupt and damaged SQL server, which tool support all king of SQL server version and Windows OS. Visit here:
Read blog post: Corrupt MDF File Repair Utility

Apr 17, 2014 | Business & Productivity Software

4 Answers

How get sql data backup

there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

4 Answers

Restoring files from the database

I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.

oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup

Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Sql script


The best way to accomplish your task is to Start SQL Management Studio. Go to Management, there you will see Maintanence Plans. When you create a new maintanence plan there is a wizard that will walk you through eveything. (What, where and when to backup). Maintanence plans can also do much more like DBCC (consistancy checks) log truncation and more.

If you're backing up to a folder on another server, just make sure the folder is shared.

Hope that helps.


Nov 21, 2007 | Microsoft SQL Server Standard Edition for...

1 Answer

Automatic database backup

These instructions are for Microsoft SQL Server Standard.
Go into the Enterprise manager.
Select your server on the tree view on the left. Go all the way down to "Management" and click on "Backup".
This will allow you to set up the backup.
Check the box called "Schedule". This will allow you to select a schedule for automatically performing the backup.
Good Luck.

Oct 18, 2007 | Microsoft SQL Server Standard Edition for...

1 Answer


open sql server management studio and go to Management -->Maintenance Plans and create a maintanance plan for this.

Oct 17, 2007 | Microsoft SQL Server Standard Edition for...

3 Answers


Well there is more than one or two answers 4 that.
you should first check if you are at simple recovery mode. If not (now this will sound strange) right click the database, click tasks/backup and make a LOG backup.
Now right click databases and click Restore Database.
You should choose a new database name (for restore practice) .
You will probably have your last backups at the bottom of the screen...if not click add and choose you latest data backup.
click the log backup and the data backup should be checked , too. on options tab make sure the database is left ready to use.

Oct 16, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

38 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides