Question about Microsoft SQL Server 2000 Standard Edition for PC

Open Question

I have SQL Server 2005 Standard edition running and have created Backup remotely. I am trying to replicate data via pull subscription, but my database size is large, which totals up to 40 GB and also when I created transactional publication size is about 9 GB, it is really difficult to replicate the amount of database on WAN. Is is possible to backup the database and restore the database on my remote site and then I can set transactional replication for amount of data which is missing in my restored database from the date it has been backup. Need help, Thanks, Smith

Posted by on

Ad

2 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Ad
  • 9 Answers

SOURCE: replication

You need to either use a Domain Account if you are using Windows authentication or you need to use SQL server authentication.
The reason for this is because the user account that you are using only exists on the machine that you are on not on the machine that you will be replicating to.

Posted on Nov 10, 2007

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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.
http://www.sqlserver.restoretools.com/
You can read up more on SQL Server here.
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104/

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

5 Answers

Need Help to backup SQL database in safe mode


kindly choose the option safe mode with networking and then try.

Sep 10, 2009 | Microsoft Computers & Internet

1 Answer

I am trying to connect to a SQL Server 2005 DB from Visual Studio


You must create an ODBC connection to your SQL database in the Windows Control Panel. Than you can call your ODBC connection via Visual Studio 2005. You can also create a DSN in Visual Studio 2005 and reference in that way. You will not be able to connect to an MDF but instead you have to connect to the SQL Server Service. Of course the username you use to connect must have access that will be created on the SQL server.

Apr 13, 2009 | Microsoft SQL Server 2005 Standard Edition

2 Answers

Transaction replication is poosible in sql server devlper edition


SQL Server 2005 provides a lot of benefits over SQL Server 2000 including within the replication feature set.

You might be relieved to know that, although most of the benefits accrue on the side of a SQL Server 2005 Publisher, you can still set up SQL Server 2005 as a subscriber on a SQL Server 2000 Publisher. Thus, you can begin to merge in the newest release of SQL Server into an existing replication scheme. You can read more about this at http://msdn2.microsoft.com/en-us/library/ms217330.

Although major advantage to SQL Server 2005 over 2000 is that changes to the schema, such as through ALTER TABLE statements, replicate out to all subscribing servers. The cool news in a mixed version environment is that the ALTER TABLE statements will be published to SQL Server 2000 Subscribers from a SQL Server 2005 Publisher.

Very cool!

Jan 30, 2009 | Televison & Video

3 Answers

System State not successfully


This is common in the following OS.

• Microsoft Windows Server 2003, Web Edition • Microsoft Windows Server 2003, Standard Edition (32-bit x86) • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86) • Microsoft Windows Server 2003, Enterprise x64 Edition • Microsoft Windows Small Business Server 2003 Premium Edition

This problem occurs when the following conditions are true: • You back up data from a volume that contains a Microsoft SQL Server database. • The recovery model of the SQL Server database is configured to use an option that is different from Simple.


Submit a request here to get a hotfix from Microsoft ( Its free and no product key will be asked )

http://go.microsoft.com/?linkid=6294451

Feb 18, 2008 | Microsoft Windows Server Standard 2003 for...

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...

3 Answers

Hi...........


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...

1 Answer

Help me....


You have to creat a table in the SQL server db then you can

 

a) use some windows host script or vb to read your data and insert into the db..

 

b)you can also use the acess:

0695665.jpg

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

1 Answer

Replication


You need to either use a Domain Account if you are using Windows authentication or you need to use SQL server authentication.
The reason for this is because the user account that you are using only exists on the machine that you are on not on the machine that you will be replicating to.

Sep 24, 2007 | Microsoft SQL Server Standard Edition for...

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

Related Topics:

34 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2775 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...