Thumperfla (6/26/2009)

---

To recover, a reboot has to been done to the server. Simply ending the service just hangs as well.

Currently, we are only backing up the DB using a...

bytesizedata (6/26/2009)

---

The command

Restore filelistonly from disk='backupfile' gave me the logical file names "Records" and "Records_log"

Executing

Restore database Records2009 from disk='path+filename.bak' with move datafile_name='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Records', logfile_name='C:\Program Files\Microsoft SQL...

FreeHansje (6/26/2009)

---

PS,

This is a solution I had tried first.

Don't get me wrong, but have you checked this in SSMS? I don't think so...

BTW, I have found the problem. Some options...

bytesizedata (6/26/2009)

---

Le's say the DB is named "Reports". I want to preserve and be able to access each year's records under a new name, such as "Reports2009". I...

MO (6/26/2009)

---

Hi,

Is there a reason you can't get the first backup job to call the second and so on? That way the second would only always start after the...

Try...

Agreeing to what others said, you create a login to grant access to the server as a whole and u create a User id to grant access to a database....

1. create a filegroup and a file in it

2. to move a table from one filegroup to other:

If u've got clustered index on the table, rebuild...

FreeHansje (6/26/2009)

---

Can I block specific records for a login? Something like:

SELECT c1, c2, c3 FROM Table1

WHERE c3 = 'ABC'

I can do this with a view, which said login can READ,...

vrabhadram (6/25/2009)

---

i have one more issue:

i have a job to archive data from the production to another log database(600 tables). for this purpose i have created the statements for each...

You're right. Transaction log file's physical...

This may happen because of query...

vrabhadram (6/24/2009)

---

hi all,

i'm preparing the job for our databses in production.

we have job plan like every day full backup, every one hour transactional log backups.

what i'm following is

in the...

check if this user has sufficient permissions to restore the database.

and this user has sufficient permissions to access the file share containing the backup file

You can write something like this

create...

2 Tim 3:16 (6/24/2009)

---

Nice catch Manu, thanks for correcting me. I was under the impression that the log chain is still good in Bulk Logged mode and during...